{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "73980778",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "No.1      67\n",
       "No.2      35\n",
       "No.3       2\n",
       "No.4      27\n",
       "No.5      76\n",
       "No.6      19\n",
       "No.7      49\n",
       "No.8      51\n",
       "No.9      98\n",
       "No.10     16\n",
       "No.11    100\n",
       "No.12      0\n",
       "No.13     72\n",
       "No.14     10\n",
       "No.15     77\n",
       "No.16      8\n",
       "No.17     11\n",
       "No.18     29\n",
       "No.19     91\n",
       "No.20     95\n",
       "dtype: int64"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import random\n",
    "\n",
    "\n",
    "# data 数据，array或者list\n",
    "# index 自定义索引，可以为空，默认从0到N\n",
    "# dtype 数据类型\n",
    "# pd.Series(data=None,index=None,dtype=None)\n",
    "\n",
    "# d = np.random.randint(0,100,(3,4))\n",
    "# rows, cols = d.shape\n",
    "d = [random.randint(0,100) for i in range(20)]\n",
    "\n",
    "idx = []\n",
    "\n",
    "for i in range(len(d)):\n",
    "    stuStr = 'No.{}'.format(i+1)\n",
    "    idx.append(stuStr)\n",
    "\n",
    "    \n",
    "table = pd.Series(data=d,index=idx)\n",
    "table\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "81f7e20e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "8月     22000\n",
       "9月     20000\n",
       "10月    26000\n",
       "11月    12000\n",
       "dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "salares = pd.Series({'8月':22000,'9月':20000,'10月':26000,'11月':12000})\n",
    "salares"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9efb892d",
   "metadata": {},
   "source": [
    "# Series 属性"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "993af5d4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['8月', '9月', '10月', '11月'], dtype='object')\n",
      "Index(['No.1', 'No.2', 'No.3', 'No.4', 'No.5', 'No.6', 'No.7', 'No.8', 'No.9',\n",
      "       'No.10', 'No.11', 'No.12', 'No.13', 'No.14', 'No.15', 'No.16', 'No.17',\n",
      "       'No.18', 'No.19', 'No.20'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "print(salares.index)\n",
    "print(table.index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "d2fcc205",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[22000 20000 26000 12000]\n",
      "[91 33 25 98  3 79 10 44 30  2 95 77 87 79 35 83 34 65 17 76]\n"
     ]
    }
   ],
   "source": [
    "print(salares.values)\n",
    "print(table.values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "05c6d272",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "20000\n",
      "33\n"
     ]
    }
   ],
   "source": [
    "print(salares[1])\n",
    "print(table[1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "d77736c3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>语文</th>\n",
       "      <th>数学</th>\n",
       "      <th>英语</th>\n",
       "      <th>政治</th>\n",
       "      <th>地理</th>\n",
       "      <th>历史</th>\n",
       "      <th>生物</th>\n",
       "      <th>物理</th>\n",
       "      <th>化学</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>学生_1</th>\n",
       "      <td>85</td>\n",
       "      <td>91</td>\n",
       "      <td>64</td>\n",
       "      <td>89</td>\n",
       "      <td>98</td>\n",
       "      <td>50</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_2</th>\n",
       "      <td>86</td>\n",
       "      <td>88</td>\n",
       "      <td>70</td>\n",
       "      <td>94</td>\n",
       "      <td>95</td>\n",
       "      <td>67</td>\n",
       "      <td>81</td>\n",
       "      <td>92</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_3</th>\n",
       "      <td>74</td>\n",
       "      <td>76</td>\n",
       "      <td>52</td>\n",
       "      <td>67</td>\n",
       "      <td>72</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>75</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_4</th>\n",
       "      <td>92</td>\n",
       "      <td>74</td>\n",
       "      <td>70</td>\n",
       "      <td>62</td>\n",
       "      <td>89</td>\n",
       "      <td>64</td>\n",
       "      <td>59</td>\n",
       "      <td>51</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_5</th>\n",
       "      <td>91</td>\n",
       "      <td>57</td>\n",
       "      <td>79</td>\n",
       "      <td>71</td>\n",
       "      <td>85</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>53</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_6</th>\n",
       "      <td>92</td>\n",
       "      <td>51</td>\n",
       "      <td>61</td>\n",
       "      <td>95</td>\n",
       "      <td>60</td>\n",
       "      <td>68</td>\n",
       "      <td>54</td>\n",
       "      <td>57</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_7</th>\n",
       "      <td>58</td>\n",
       "      <td>54</td>\n",
       "      <td>63</td>\n",
       "      <td>70</td>\n",
       "      <td>83</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "      <td>59</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_8</th>\n",
       "      <td>54</td>\n",
       "      <td>69</td>\n",
       "      <td>61</td>\n",
       "      <td>72</td>\n",
       "      <td>87</td>\n",
       "      <td>95</td>\n",
       "      <td>71</td>\n",
       "      <td>72</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_9</th>\n",
       "      <td>98</td>\n",
       "      <td>55</td>\n",
       "      <td>99</td>\n",
       "      <td>78</td>\n",
       "      <td>67</td>\n",
       "      <td>50</td>\n",
       "      <td>56</td>\n",
       "      <td>89</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_10</th>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>59</td>\n",
       "      <td>88</td>\n",
       "      <td>82</td>\n",
       "      <td>87</td>\n",
       "      <td>61</td>\n",
       "      <td>66</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_11</th>\n",
       "      <td>88</td>\n",
       "      <td>64</td>\n",
       "      <td>63</td>\n",
       "      <td>92</td>\n",
       "      <td>87</td>\n",
       "      <td>51</td>\n",
       "      <td>83</td>\n",
       "      <td>56</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_12</th>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>77</td>\n",
       "      <td>93</td>\n",
       "      <td>78</td>\n",
       "      <td>96</td>\n",
       "      <td>86</td>\n",
       "      <td>85</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_13</th>\n",
       "      <td>76</td>\n",
       "      <td>70</td>\n",
       "      <td>56</td>\n",
       "      <td>82</td>\n",
       "      <td>68</td>\n",
       "      <td>65</td>\n",
       "      <td>87</td>\n",
       "      <td>97</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_14</th>\n",
       "      <td>53</td>\n",
       "      <td>95</td>\n",
       "      <td>53</td>\n",
       "      <td>96</td>\n",
       "      <td>60</td>\n",
       "      <td>93</td>\n",
       "      <td>91</td>\n",
       "      <td>88</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_15</th>\n",
       "      <td>65</td>\n",
       "      <td>67</td>\n",
       "      <td>64</td>\n",
       "      <td>92</td>\n",
       "      <td>75</td>\n",
       "      <td>72</td>\n",
       "      <td>88</td>\n",
       "      <td>54</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_16</th>\n",
       "      <td>50</td>\n",
       "      <td>76</td>\n",
       "      <td>73</td>\n",
       "      <td>78</td>\n",
       "      <td>90</td>\n",
       "      <td>66</td>\n",
       "      <td>76</td>\n",
       "      <td>77</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_17</th>\n",
       "      <td>91</td>\n",
       "      <td>63</td>\n",
       "      <td>81</td>\n",
       "      <td>97</td>\n",
       "      <td>61</td>\n",
       "      <td>83</td>\n",
       "      <td>74</td>\n",
       "      <td>56</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_18</th>\n",
       "      <td>95</td>\n",
       "      <td>88</td>\n",
       "      <td>56</td>\n",
       "      <td>65</td>\n",
       "      <td>59</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>91</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_19</th>\n",
       "      <td>88</td>\n",
       "      <td>69</td>\n",
       "      <td>96</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>53</td>\n",
       "      <td>71</td>\n",
       "      <td>59</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_20</th>\n",
       "      <td>96</td>\n",
       "      <td>66</td>\n",
       "      <td>91</td>\n",
       "      <td>92</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "      <td>59</td>\n",
       "      <td>53</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_21</th>\n",
       "      <td>59</td>\n",
       "      <td>71</td>\n",
       "      <td>86</td>\n",
       "      <td>91</td>\n",
       "      <td>82</td>\n",
       "      <td>97</td>\n",
       "      <td>52</td>\n",
       "      <td>81</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_22</th>\n",
       "      <td>78</td>\n",
       "      <td>55</td>\n",
       "      <td>89</td>\n",
       "      <td>55</td>\n",
       "      <td>79</td>\n",
       "      <td>71</td>\n",
       "      <td>88</td>\n",
       "      <td>82</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_23</th>\n",
       "      <td>92</td>\n",
       "      <td>95</td>\n",
       "      <td>58</td>\n",
       "      <td>84</td>\n",
       "      <td>77</td>\n",
       "      <td>56</td>\n",
       "      <td>64</td>\n",
       "      <td>90</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_24</th>\n",
       "      <td>81</td>\n",
       "      <td>61</td>\n",
       "      <td>97</td>\n",
       "      <td>62</td>\n",
       "      <td>87</td>\n",
       "      <td>69</td>\n",
       "      <td>57</td>\n",
       "      <td>91</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_25</th>\n",
       "      <td>85</td>\n",
       "      <td>72</td>\n",
       "      <td>59</td>\n",
       "      <td>64</td>\n",
       "      <td>79</td>\n",
       "      <td>93</td>\n",
       "      <td>57</td>\n",
       "      <td>57</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_26</th>\n",
       "      <td>83</td>\n",
       "      <td>92</td>\n",
       "      <td>50</td>\n",
       "      <td>57</td>\n",
       "      <td>86</td>\n",
       "      <td>65</td>\n",
       "      <td>84</td>\n",
       "      <td>69</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_27</th>\n",
       "      <td>54</td>\n",
       "      <td>70</td>\n",
       "      <td>52</td>\n",
       "      <td>75</td>\n",
       "      <td>61</td>\n",
       "      <td>87</td>\n",
       "      <td>98</td>\n",
       "      <td>93</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_28</th>\n",
       "      <td>61</td>\n",
       "      <td>84</td>\n",
       "      <td>86</td>\n",
       "      <td>69</td>\n",
       "      <td>87</td>\n",
       "      <td>91</td>\n",
       "      <td>90</td>\n",
       "      <td>57</td>\n",
       "      <td>69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_29</th>\n",
       "      <td>50</td>\n",
       "      <td>71</td>\n",
       "      <td>77</td>\n",
       "      <td>70</td>\n",
       "      <td>95</td>\n",
       "      <td>75</td>\n",
       "      <td>64</td>\n",
       "      <td>56</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_30</th>\n",
       "      <td>79</td>\n",
       "      <td>68</td>\n",
       "      <td>67</td>\n",
       "      <td>70</td>\n",
       "      <td>88</td>\n",
       "      <td>92</td>\n",
       "      <td>79</td>\n",
       "      <td>94</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_31</th>\n",
       "      <td>64</td>\n",
       "      <td>58</td>\n",
       "      <td>92</td>\n",
       "      <td>88</td>\n",
       "      <td>80</td>\n",
       "      <td>98</td>\n",
       "      <td>89</td>\n",
       "      <td>87</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_32</th>\n",
       "      <td>83</td>\n",
       "      <td>51</td>\n",
       "      <td>86</td>\n",
       "      <td>63</td>\n",
       "      <td>56</td>\n",
       "      <td>50</td>\n",
       "      <td>91</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_33</th>\n",
       "      <td>91</td>\n",
       "      <td>82</td>\n",
       "      <td>54</td>\n",
       "      <td>61</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>70</td>\n",
       "      <td>84</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_34</th>\n",
       "      <td>61</td>\n",
       "      <td>98</td>\n",
       "      <td>73</td>\n",
       "      <td>79</td>\n",
       "      <td>92</td>\n",
       "      <td>84</td>\n",
       "      <td>82</td>\n",
       "      <td>76</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_35</th>\n",
       "      <td>54</td>\n",
       "      <td>71</td>\n",
       "      <td>69</td>\n",
       "      <td>92</td>\n",
       "      <td>55</td>\n",
       "      <td>92</td>\n",
       "      <td>58</td>\n",
       "      <td>95</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_36</th>\n",
       "      <td>87</td>\n",
       "      <td>75</td>\n",
       "      <td>78</td>\n",
       "      <td>99</td>\n",
       "      <td>88</td>\n",
       "      <td>64</td>\n",
       "      <td>61</td>\n",
       "      <td>90</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_37</th>\n",
       "      <td>81</td>\n",
       "      <td>73</td>\n",
       "      <td>82</td>\n",
       "      <td>56</td>\n",
       "      <td>69</td>\n",
       "      <td>53</td>\n",
       "      <td>68</td>\n",
       "      <td>78</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_38</th>\n",
       "      <td>52</td>\n",
       "      <td>67</td>\n",
       "      <td>69</td>\n",
       "      <td>92</td>\n",
       "      <td>86</td>\n",
       "      <td>57</td>\n",
       "      <td>84</td>\n",
       "      <td>77</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_39</th>\n",
       "      <td>64</td>\n",
       "      <td>92</td>\n",
       "      <td>87</td>\n",
       "      <td>89</td>\n",
       "      <td>75</td>\n",
       "      <td>69</td>\n",
       "      <td>54</td>\n",
       "      <td>59</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_40</th>\n",
       "      <td>68</td>\n",
       "      <td>93</td>\n",
       "      <td>60</td>\n",
       "      <td>57</td>\n",
       "      <td>61</td>\n",
       "      <td>93</td>\n",
       "      <td>87</td>\n",
       "      <td>92</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_41</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>61</td>\n",
       "      <td>71</td>\n",
       "      <td>66</td>\n",
       "      <td>56</td>\n",
       "      <td>85</td>\n",
       "      <td>67</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_42</th>\n",
       "      <td>91</td>\n",
       "      <td>52</td>\n",
       "      <td>79</td>\n",
       "      <td>58</td>\n",
       "      <td>69</td>\n",
       "      <td>85</td>\n",
       "      <td>72</td>\n",
       "      <td>61</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_43</th>\n",
       "      <td>90</td>\n",
       "      <td>82</td>\n",
       "      <td>69</td>\n",
       "      <td>76</td>\n",
       "      <td>59</td>\n",
       "      <td>91</td>\n",
       "      <td>88</td>\n",
       "      <td>97</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_44</th>\n",
       "      <td>68</td>\n",
       "      <td>98</td>\n",
       "      <td>93</td>\n",
       "      <td>89</td>\n",
       "      <td>76</td>\n",
       "      <td>97</td>\n",
       "      <td>83</td>\n",
       "      <td>96</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_45</th>\n",
       "      <td>81</td>\n",
       "      <td>99</td>\n",
       "      <td>92</td>\n",
       "      <td>96</td>\n",
       "      <td>71</td>\n",
       "      <td>84</td>\n",
       "      <td>74</td>\n",
       "      <td>79</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_46</th>\n",
       "      <td>60</td>\n",
       "      <td>71</td>\n",
       "      <td>62</td>\n",
       "      <td>50</td>\n",
       "      <td>99</td>\n",
       "      <td>58</td>\n",
       "      <td>89</td>\n",
       "      <td>60</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_47</th>\n",
       "      <td>71</td>\n",
       "      <td>64</td>\n",
       "      <td>60</td>\n",
       "      <td>71</td>\n",
       "      <td>99</td>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>92</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_48</th>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>62</td>\n",
       "      <td>82</td>\n",
       "      <td>50</td>\n",
       "      <td>81</td>\n",
       "      <td>83</td>\n",
       "      <td>81</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_49</th>\n",
       "      <td>56</td>\n",
       "      <td>97</td>\n",
       "      <td>57</td>\n",
       "      <td>58</td>\n",
       "      <td>79</td>\n",
       "      <td>65</td>\n",
       "      <td>76</td>\n",
       "      <td>59</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_50</th>\n",
       "      <td>84</td>\n",
       "      <td>83</td>\n",
       "      <td>65</td>\n",
       "      <td>53</td>\n",
       "      <td>54</td>\n",
       "      <td>71</td>\n",
       "      <td>56</td>\n",
       "      <td>74</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_51</th>\n",
       "      <td>59</td>\n",
       "      <td>88</td>\n",
       "      <td>50</td>\n",
       "      <td>94</td>\n",
       "      <td>86</td>\n",
       "      <td>87</td>\n",
       "      <td>60</td>\n",
       "      <td>62</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_52</th>\n",
       "      <td>88</td>\n",
       "      <td>76</td>\n",
       "      <td>92</td>\n",
       "      <td>95</td>\n",
       "      <td>55</td>\n",
       "      <td>87</td>\n",
       "      <td>57</td>\n",
       "      <td>50</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_53</th>\n",
       "      <td>99</td>\n",
       "      <td>94</td>\n",
       "      <td>81</td>\n",
       "      <td>85</td>\n",
       "      <td>91</td>\n",
       "      <td>94</td>\n",
       "      <td>64</td>\n",
       "      <td>92</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_54</th>\n",
       "      <td>82</td>\n",
       "      <td>68</td>\n",
       "      <td>75</td>\n",
       "      <td>54</td>\n",
       "      <td>77</td>\n",
       "      <td>59</td>\n",
       "      <td>50</td>\n",
       "      <td>90</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_55</th>\n",
       "      <td>59</td>\n",
       "      <td>96</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>56</td>\n",
       "      <td>72</td>\n",
       "      <td>84</td>\n",
       "      <td>96</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_56</th>\n",
       "      <td>68</td>\n",
       "      <td>81</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>81</td>\n",
       "      <td>94</td>\n",
       "      <td>93</td>\n",
       "      <td>77</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_57</th>\n",
       "      <td>65</td>\n",
       "      <td>59</td>\n",
       "      <td>53</td>\n",
       "      <td>55</td>\n",
       "      <td>60</td>\n",
       "      <td>66</td>\n",
       "      <td>62</td>\n",
       "      <td>70</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_58</th>\n",
       "      <td>64</td>\n",
       "      <td>77</td>\n",
       "      <td>85</td>\n",
       "      <td>91</td>\n",
       "      <td>50</td>\n",
       "      <td>84</td>\n",
       "      <td>94</td>\n",
       "      <td>98</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_59</th>\n",
       "      <td>63</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>62</td>\n",
       "      <td>81</td>\n",
       "      <td>59</td>\n",
       "      <td>74</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_60</th>\n",
       "      <td>72</td>\n",
       "      <td>74</td>\n",
       "      <td>97</td>\n",
       "      <td>96</td>\n",
       "      <td>74</td>\n",
       "      <td>52</td>\n",
       "      <td>95</td>\n",
       "      <td>73</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       语文  数学  英语  政治  地理  历史  生物  物理  化学\n",
       "学生_1   85  91  64  89  98  50  51  52  54\n",
       "学生_2   86  88  70  94  95  67  81  92  90\n",
       "学生_3   74  76  52  67  72  68  63  75  84\n",
       "学生_4   92  74  70  62  89  64  59  51  91\n",
       "学生_5   91  57  79  71  85  66  66  53  86\n",
       "学生_6   92  51  61  95  60  68  54  57  87\n",
       "学生_7   58  54  63  70  83  85  82  59  66\n",
       "学生_8   54  69  61  72  87  95  71  72  78\n",
       "学生_9   98  55  99  78  67  50  56  89  83\n",
       "学生_10  53  53  59  88  82  87  61  66  77\n",
       "学生_11  88  64  63  92  87  51  83  56  60\n",
       "学生_12  72  70  77  93  78  96  86  85  54\n",
       "学生_13  76  70  56  82  68  65  87  97  51\n",
       "学生_14  53  95  53  96  60  93  91  88  79\n",
       "学生_15  65  67  64  92  75  72  88  54  87\n",
       "学生_16  50  76  73  78  90  66  76  77  54\n",
       "学生_17  91  63  81  97  61  83  74  56  85\n",
       "学生_18  95  88  56  65  59  78  84  91  74\n",
       "学生_19  88  69  96  56  56  53  71  59  94\n",
       "学生_20  96  66  91  92  85  82  59  53  58\n",
       "学生_21  59  71  86  91  82  97  52  81  82\n",
       "学生_22  78  55  89  55  79  71  88  82  83\n",
       "学生_23  92  95  58  84  77  56  64  90  77\n",
       "学生_24  81  61  97  62  87  69  57  91  95\n",
       "学生_25  85  72  59  64  79  93  57  57  96\n",
       "学生_26  83  92  50  57  86  65  84  69  91\n",
       "学生_27  54  70  52  75  61  87  98  93  51\n",
       "学生_28  61  84  86  69  87  91  90  57  69\n",
       "学生_29  50  71  77  70  95  75  64  56  81\n",
       "学生_30  79  68  67  70  88  92  79  94  93\n",
       "学生_31  64  58  92  88  80  98  89  87  52\n",
       "学生_32  83  51  86  63  56  50  91  85  82\n",
       "学生_33  91  82  54  61  51  52  70  84  98\n",
       "学生_34  61  98  73  79  92  84  82  76  89\n",
       "学生_35  54  71  69  92  55  92  58  95  79\n",
       "学生_36  87  75  78  99  88  64  61  90  58\n",
       "学生_37  81  73  82  56  69  53  68  78  60\n",
       "学生_38  52  67  69  92  86  57  84  77  66\n",
       "学生_39  64  92  87  89  75  69  54  59  90\n",
       "学生_40  68  93  60  57  61  93  87  92  79\n",
       "学生_41  50  53  61  71  66  56  85  67  81\n",
       "学生_42  91  52  79  58  69  85  72  61  51\n",
       "学生_43  90  82  69  76  59  91  88  97  72\n",
       "学生_44  68  98  93  89  76  97  83  96  66\n",
       "学生_45  81  99  92  96  71  84  74  79  73\n",
       "学生_46  60  71  62  50  99  58  89  60  76\n",
       "学生_47  71  64  60  71  99  72  70  92  89\n",
       "学生_48  67  73  62  82  50  81  83  81  56\n",
       "学生_49  56  97  57  58  79  65  76  59  54\n",
       "学生_50  84  83  65  53  54  71  56  74  61\n",
       "学生_51  59  88  50  94  86  87  60  62  91\n",
       "学生_52  88  76  92  95  55  87  57  50  64\n",
       "学生_53  99  94  81  85  91  94  64  92  54\n",
       "学生_54  82  68  75  54  77  59  50  90  50\n",
       "学生_55  59  96  68  63  56  72  84  96  56\n",
       "学生_56  68  81  55  65  81  94  93  77  92\n",
       "学生_57  65  59  53  55  60  66  62  70  71\n",
       "学生_58  64  77  85  91  50  84  94  98  61\n",
       "学生_59  63  55  65  90  62  81  59  74  68\n",
       "学生_60  72  74  97  96  74  52  95  73  56"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import random\n",
    "\n",
    "studentCount = 60\n",
    "subject = ['语文','数学','英语','政治','地理','历史','生物','物理','化学']\n",
    "\n",
    "\n",
    "# 初始化同学列表 1\n",
    "# students = []\n",
    "# for i in range(30):\n",
    "#     students.append('同学{}'.format(i+1))\n",
    "    \n",
    "students = ['学生_'+ str(i+1) for i in range(studentCount)]\n",
    "\n",
    "exameScore = pd.DataFrame(data=np.random.randint(50,100,(studentCount,len(subject))),index=students,columns=subject)\n",
    "exameScore"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "19c56299",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>合格科目数</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>学生_1</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_2</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_3</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_4</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_5</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_6</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_7</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_8</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_9</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_10</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_11</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_12</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_13</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_14</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_15</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_16</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_17</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_18</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_19</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_20</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_21</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_22</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_23</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_24</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_25</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_26</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_27</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_28</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_29</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_30</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_31</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_32</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_33</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_34</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_35</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_36</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_37</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_38</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_39</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_40</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_41</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_42</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_43</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_44</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_45</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_46</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_47</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_48</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_49</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_50</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_51</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_52</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_53</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_54</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_55</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_56</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_57</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_58</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_59</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_60</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       合格科目数\n",
       "学生_1       5\n",
       "学生_2       9\n",
       "学生_3       8\n",
       "学生_4       7\n",
       "学生_5       7\n",
       "学生_6       6\n",
       "学生_7       6\n",
       "学生_8       8\n",
       "学生_9       6\n",
       "学生_10      6\n",
       "学生_11      7\n",
       "学生_12      8\n",
       "学生_13      7\n",
       "学生_14      7\n",
       "学生_15      8\n",
       "学生_16      7\n",
       "学生_17      8\n",
       "学生_18      7\n",
       "学生_19      5\n",
       "学生_20      6\n",
       "学生_21      7\n",
       "学生_22      7\n",
       "学生_23      7\n",
       "学生_24      8\n",
       "学生_25      6\n",
       "学生_26      7\n",
       "学生_27      6\n",
       "学生_28      8\n",
       "学生_29      7\n",
       "学生_30      9\n",
       "学生_31      7\n",
       "学生_32      6\n",
       "学生_33      6\n",
       "学生_34      9\n",
       "学生_35      6\n",
       "学生_36      8\n",
       "学生_37      7\n",
       "学生_38      7\n",
       "学生_39      7\n",
       "学生_40      8\n",
       "学生_41      6\n",
       "学生_42      6\n",
       "学生_43      8\n",
       "学生_44      9\n",
       "学生_45      9\n",
       "学生_46      7\n",
       "学生_47      9\n",
       "学生_48      7\n",
       "学生_49      4\n",
       "学生_50      6\n",
       "学生_51      7\n",
       "学生_52      6\n",
       "学生_53      8\n",
       "学生_54      5\n",
       "学生_55      6\n",
       "学生_56      8\n",
       "学生_57      6\n",
       "学生_58      8\n",
       "学生_59      7\n",
       "学生_60      7"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 统计所有同学合格的科目数\n",
    "result = np.where(exameScore<60,0,1)\n",
    "passResult = np.sum(result,axis=1)\n",
    "pd.DataFrame(passResult,index=students,columns=['合格科目数'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "80a4ce2e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>不及格科目数</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>学生_1</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_2</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_3</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_4</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_5</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_6</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_7</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_8</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_9</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_10</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_11</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_12</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_13</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_14</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_15</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_16</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_17</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_18</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_19</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_20</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_21</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_22</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_23</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_24</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_25</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_26</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_27</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_28</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_29</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_30</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_31</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_32</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_33</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_34</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_35</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_36</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_37</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_38</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_39</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_40</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_41</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_42</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_43</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_44</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_45</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_46</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_47</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_48</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_49</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_50</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_51</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_52</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_53</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_54</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_55</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_56</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_57</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_58</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_59</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_60</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       不及格科目数\n",
       "学生_1        4\n",
       "学生_2        0\n",
       "学生_3        1\n",
       "学生_4        2\n",
       "学生_5        2\n",
       "学生_6        3\n",
       "学生_7        3\n",
       "学生_8        1\n",
       "学生_9        3\n",
       "学生_10       3\n",
       "学生_11       2\n",
       "学生_12       1\n",
       "学生_13       2\n",
       "学生_14       2\n",
       "学生_15       1\n",
       "学生_16       2\n",
       "学生_17       1\n",
       "学生_18       2\n",
       "学生_19       4\n",
       "学生_20       3\n",
       "学生_21       2\n",
       "学生_22       2\n",
       "学生_23       2\n",
       "学生_24       1\n",
       "学生_25       3\n",
       "学生_26       2\n",
       "学生_27       3\n",
       "学生_28       1\n",
       "学生_29       2\n",
       "学生_30       0\n",
       "学生_31       2\n",
       "学生_32       3\n",
       "学生_33       3\n",
       "学生_34       0\n",
       "学生_35       3\n",
       "学生_36       1\n",
       "学生_37       2\n",
       "学生_38       2\n",
       "学生_39       2\n",
       "学生_40       1\n",
       "学生_41       3\n",
       "学生_42       3\n",
       "学生_43       1\n",
       "学生_44       0\n",
       "学生_45       0\n",
       "学生_46       2\n",
       "学生_47       0\n",
       "学生_48       2\n",
       "学生_49       5\n",
       "学生_50       3\n",
       "学生_51       2\n",
       "学生_52       3\n",
       "学生_53       1\n",
       "学生_54       4\n",
       "学生_55       3\n",
       "学生_56       1\n",
       "学生_57       3\n",
       "学生_58       1\n",
       "学生_59       2\n",
       "学生_60       2"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "failResult = 9 - np.sum(result,axis=1)\n",
    "pd.DataFrame(failResult,index=students,columns=['不及格科目数'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "4f6a147e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(30, 9)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "exameScore.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "09555379",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['同学1', '同学2', '同学3', '同学4', '同学5', '同学6', '同学7', '同学8', '同学9', '同学10',\n",
       "       '同学11', '同学12', '同学13', '同学14', '同学15', '同学16', '同学17', '同学18', '同学19',\n",
       "       '同学20', '同学21', '同学22', '同学23', '同学24', '同学25', '同学26', '同学27', '同学28',\n",
       "       '同学29', '同学30'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "exameScore.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a45eb72a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[79, 86, 72, 97, 87, 54, 80, 62, 67],\n",
       "       [93, 86, 68, 88, 99, 96, 87, 67, 98],\n",
       "       [91, 77, 99, 63, 72, 66, 76, 50, 59],\n",
       "       [85, 77, 82, 84, 62, 64, 89, 67, 64],\n",
       "       [74, 68, 63, 87, 94, 71, 83, 97, 95],\n",
       "       [63, 75, 59, 78, 95, 69, 83, 51, 56],\n",
       "       [78, 99, 96, 95, 63, 84, 84, 75, 75],\n",
       "       [76, 77, 69, 84, 92, 75, 74, 59, 57],\n",
       "       [60, 66, 94, 70, 61, 75, 99, 85, 71],\n",
       "       [66, 85, 99, 76, 71, 73, 90, 72, 74],\n",
       "       [90, 73, 77, 89, 89, 76, 66, 68, 60],\n",
       "       [63, 93, 83, 86, 59, 96, 53, 53, 75],\n",
       "       [95, 68, 52, 72, 77, 62, 64, 76, 80],\n",
       "       [68, 85, 91, 58, 86, 76, 68, 86, 60],\n",
       "       [97, 76, 82, 98, 90, 80, 78, 86, 59],\n",
       "       [92, 77, 99, 50, 97, 89, 63, 59, 56],\n",
       "       [56, 61, 60, 96, 98, 75, 71, 87, 92],\n",
       "       [57, 64, 61, 89, 95, 85, 55, 91, 92],\n",
       "       [70, 83, 60, 95, 69, 86, 59, 54, 80],\n",
       "       [79, 96, 91, 76, 88, 52, 79, 55, 73],\n",
       "       [76, 62, 69, 79, 55, 72, 90, 96, 81],\n",
       "       [53, 71, 58, 87, 99, 99, 88, 86, 60],\n",
       "       [88, 85, 89, 72, 75, 73, 55, 59, 53],\n",
       "       [55, 57, 73, 90, 97, 95, 99, 86, 51],\n",
       "       [98, 82, 85, 89, 89, 53, 55, 70, 91],\n",
       "       [50, 82, 71, 58, 56, 94, 74, 66, 93],\n",
       "       [77, 82, 90, 59, 92, 55, 74, 95, 99],\n",
       "       [80, 69, 87, 68, 68, 62, 93, 86, 57],\n",
       "       [66, 74, 64, 67, 72, 82, 78, 53, 74],\n",
       "       [56, 92, 75, 64, 99, 98, 50, 82, 59]])"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "exameScore.values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "d35810f2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>同学1</th>\n",
       "      <th>同学2</th>\n",
       "      <th>同学3</th>\n",
       "      <th>同学4</th>\n",
       "      <th>同学5</th>\n",
       "      <th>同学6</th>\n",
       "      <th>同学7</th>\n",
       "      <th>同学8</th>\n",
       "      <th>同学9</th>\n",
       "      <th>同学10</th>\n",
       "      <th>...</th>\n",
       "      <th>同学21</th>\n",
       "      <th>同学22</th>\n",
       "      <th>同学23</th>\n",
       "      <th>同学24</th>\n",
       "      <th>同学25</th>\n",
       "      <th>同学26</th>\n",
       "      <th>同学27</th>\n",
       "      <th>同学28</th>\n",
       "      <th>同学29</th>\n",
       "      <th>同学30</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>语文</th>\n",
       "      <td>79</td>\n",
       "      <td>93</td>\n",
       "      <td>91</td>\n",
       "      <td>85</td>\n",
       "      <td>74</td>\n",
       "      <td>63</td>\n",
       "      <td>78</td>\n",
       "      <td>76</td>\n",
       "      <td>60</td>\n",
       "      <td>66</td>\n",
       "      <td>...</td>\n",
       "      <td>76</td>\n",
       "      <td>53</td>\n",
       "      <td>88</td>\n",
       "      <td>55</td>\n",
       "      <td>98</td>\n",
       "      <td>50</td>\n",
       "      <td>77</td>\n",
       "      <td>80</td>\n",
       "      <td>66</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>数学</th>\n",
       "      <td>86</td>\n",
       "      <td>86</td>\n",
       "      <td>77</td>\n",
       "      <td>77</td>\n",
       "      <td>68</td>\n",
       "      <td>75</td>\n",
       "      <td>99</td>\n",
       "      <td>77</td>\n",
       "      <td>66</td>\n",
       "      <td>85</td>\n",
       "      <td>...</td>\n",
       "      <td>62</td>\n",
       "      <td>71</td>\n",
       "      <td>85</td>\n",
       "      <td>57</td>\n",
       "      <td>82</td>\n",
       "      <td>82</td>\n",
       "      <td>82</td>\n",
       "      <td>69</td>\n",
       "      <td>74</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>英语</th>\n",
       "      <td>72</td>\n",
       "      <td>68</td>\n",
       "      <td>99</td>\n",
       "      <td>82</td>\n",
       "      <td>63</td>\n",
       "      <td>59</td>\n",
       "      <td>96</td>\n",
       "      <td>69</td>\n",
       "      <td>94</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>69</td>\n",
       "      <td>58</td>\n",
       "      <td>89</td>\n",
       "      <td>73</td>\n",
       "      <td>85</td>\n",
       "      <td>71</td>\n",
       "      <td>90</td>\n",
       "      <td>87</td>\n",
       "      <td>64</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>政治</th>\n",
       "      <td>97</td>\n",
       "      <td>88</td>\n",
       "      <td>63</td>\n",
       "      <td>84</td>\n",
       "      <td>87</td>\n",
       "      <td>78</td>\n",
       "      <td>95</td>\n",
       "      <td>84</td>\n",
       "      <td>70</td>\n",
       "      <td>76</td>\n",
       "      <td>...</td>\n",
       "      <td>79</td>\n",
       "      <td>87</td>\n",
       "      <td>72</td>\n",
       "      <td>90</td>\n",
       "      <td>89</td>\n",
       "      <td>58</td>\n",
       "      <td>59</td>\n",
       "      <td>68</td>\n",
       "      <td>67</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>地理</th>\n",
       "      <td>87</td>\n",
       "      <td>99</td>\n",
       "      <td>72</td>\n",
       "      <td>62</td>\n",
       "      <td>94</td>\n",
       "      <td>95</td>\n",
       "      <td>63</td>\n",
       "      <td>92</td>\n",
       "      <td>61</td>\n",
       "      <td>71</td>\n",
       "      <td>...</td>\n",
       "      <td>55</td>\n",
       "      <td>99</td>\n",
       "      <td>75</td>\n",
       "      <td>97</td>\n",
       "      <td>89</td>\n",
       "      <td>56</td>\n",
       "      <td>92</td>\n",
       "      <td>68</td>\n",
       "      <td>72</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>历史</th>\n",
       "      <td>54</td>\n",
       "      <td>96</td>\n",
       "      <td>66</td>\n",
       "      <td>64</td>\n",
       "      <td>71</td>\n",
       "      <td>69</td>\n",
       "      <td>84</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>73</td>\n",
       "      <td>...</td>\n",
       "      <td>72</td>\n",
       "      <td>99</td>\n",
       "      <td>73</td>\n",
       "      <td>95</td>\n",
       "      <td>53</td>\n",
       "      <td>94</td>\n",
       "      <td>55</td>\n",
       "      <td>62</td>\n",
       "      <td>82</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>生物</th>\n",
       "      <td>80</td>\n",
       "      <td>87</td>\n",
       "      <td>76</td>\n",
       "      <td>89</td>\n",
       "      <td>83</td>\n",
       "      <td>83</td>\n",
       "      <td>84</td>\n",
       "      <td>74</td>\n",
       "      <td>99</td>\n",
       "      <td>90</td>\n",
       "      <td>...</td>\n",
       "      <td>90</td>\n",
       "      <td>88</td>\n",
       "      <td>55</td>\n",
       "      <td>99</td>\n",
       "      <td>55</td>\n",
       "      <td>74</td>\n",
       "      <td>74</td>\n",
       "      <td>93</td>\n",
       "      <td>78</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>物理</th>\n",
       "      <td>62</td>\n",
       "      <td>67</td>\n",
       "      <td>50</td>\n",
       "      <td>67</td>\n",
       "      <td>97</td>\n",
       "      <td>51</td>\n",
       "      <td>75</td>\n",
       "      <td>59</td>\n",
       "      <td>85</td>\n",
       "      <td>72</td>\n",
       "      <td>...</td>\n",
       "      <td>96</td>\n",
       "      <td>86</td>\n",
       "      <td>59</td>\n",
       "      <td>86</td>\n",
       "      <td>70</td>\n",
       "      <td>66</td>\n",
       "      <td>95</td>\n",
       "      <td>86</td>\n",
       "      <td>53</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>化学</th>\n",
       "      <td>67</td>\n",
       "      <td>98</td>\n",
       "      <td>59</td>\n",
       "      <td>64</td>\n",
       "      <td>95</td>\n",
       "      <td>56</td>\n",
       "      <td>75</td>\n",
       "      <td>57</td>\n",
       "      <td>71</td>\n",
       "      <td>74</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>60</td>\n",
       "      <td>53</td>\n",
       "      <td>51</td>\n",
       "      <td>91</td>\n",
       "      <td>93</td>\n",
       "      <td>99</td>\n",
       "      <td>57</td>\n",
       "      <td>74</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    同学1  同学2  同学3  同学4  同学5  同学6  同学7  同学8  同学9  同学10  ...  同学21  同学22  同学23  \\\n",
       "语文   79   93   91   85   74   63   78   76   60    66  ...    76    53    88   \n",
       "数学   86   86   77   77   68   75   99   77   66    85  ...    62    71    85   \n",
       "英语   72   68   99   82   63   59   96   69   94    99  ...    69    58    89   \n",
       "政治   97   88   63   84   87   78   95   84   70    76  ...    79    87    72   \n",
       "地理   87   99   72   62   94   95   63   92   61    71  ...    55    99    75   \n",
       "历史   54   96   66   64   71   69   84   75   75    73  ...    72    99    73   \n",
       "生物   80   87   76   89   83   83   84   74   99    90  ...    90    88    55   \n",
       "物理   62   67   50   67   97   51   75   59   85    72  ...    96    86    59   \n",
       "化学   67   98   59   64   95   56   75   57   71    74  ...    81    60    53   \n",
       "\n",
       "    同学24  同学25  同学26  同学27  同学28  同学29  同学30  \n",
       "语文    55    98    50    77    80    66    56  \n",
       "数学    57    82    82    82    69    74    92  \n",
       "英语    73    85    71    90    87    64    75  \n",
       "政治    90    89    58    59    68    67    64  \n",
       "地理    97    89    56    92    68    72    99  \n",
       "历史    95    53    94    55    62    82    98  \n",
       "生物    99    55    74    74    93    78    50  \n",
       "物理    86    70    66    95    86    53    82  \n",
       "化学    51    91    93    99    57    74    59  \n",
       "\n",
       "[9 rows x 30 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "exameScore.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "0d85147f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>语文</th>\n",
       "      <th>数学</th>\n",
       "      <th>英语</th>\n",
       "      <th>政治</th>\n",
       "      <th>地理</th>\n",
       "      <th>历史</th>\n",
       "      <th>生物</th>\n",
       "      <th>物理</th>\n",
       "      <th>化学</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>同学26</th>\n",
       "      <td>50</td>\n",
       "      <td>82</td>\n",
       "      <td>71</td>\n",
       "      <td>58</td>\n",
       "      <td>56</td>\n",
       "      <td>94</td>\n",
       "      <td>74</td>\n",
       "      <td>66</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>同学27</th>\n",
       "      <td>77</td>\n",
       "      <td>82</td>\n",
       "      <td>90</td>\n",
       "      <td>59</td>\n",
       "      <td>92</td>\n",
       "      <td>55</td>\n",
       "      <td>74</td>\n",
       "      <td>95</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>同学28</th>\n",
       "      <td>80</td>\n",
       "      <td>69</td>\n",
       "      <td>87</td>\n",
       "      <td>68</td>\n",
       "      <td>68</td>\n",
       "      <td>62</td>\n",
       "      <td>93</td>\n",
       "      <td>86</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>同学29</th>\n",
       "      <td>66</td>\n",
       "      <td>74</td>\n",
       "      <td>64</td>\n",
       "      <td>67</td>\n",
       "      <td>72</td>\n",
       "      <td>82</td>\n",
       "      <td>78</td>\n",
       "      <td>53</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>同学30</th>\n",
       "      <td>56</td>\n",
       "      <td>92</td>\n",
       "      <td>75</td>\n",
       "      <td>64</td>\n",
       "      <td>99</td>\n",
       "      <td>98</td>\n",
       "      <td>50</td>\n",
       "      <td>82</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      语文  数学  英语  政治  地理  历史  生物  物理  化学\n",
       "同学26  50  82  71  58  56  94  74  66  93\n",
       "同学27  77  82  90  59  92  55  74  95  99\n",
       "同学28  80  69  87  68  68  62  93  86  57\n",
       "同学29  66  74  64  67  72  82  78  53  74\n",
       "同学30  56  92  75  64  99  98  50  82  59"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# head 和 tail 默认前五行\n",
    "# exameScore.head()\n",
    "exameScore.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "54119ed9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>平均分</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>语文</th>\n",
       "      <td>73.683333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>数学</th>\n",
       "      <td>73.916667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>英语</th>\n",
       "      <td>71.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>政治</th>\n",
       "      <td>76.566667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>地理</th>\n",
       "      <td>74.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>历史</th>\n",
       "      <td>74.716667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>生物</th>\n",
       "      <td>73.566667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>物理</th>\n",
       "      <td>75.383333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>化学</th>\n",
       "      <td>73.416667</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          平均分\n",
       "语文  73.683333\n",
       "数学  73.916667\n",
       "英语  71.333333\n",
       "政治  76.566667\n",
       "地理  74.750000\n",
       "历史  74.716667\n",
       "生物  73.566667\n",
       "物理  75.383333\n",
       "化学  73.416667"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 各科平均分\n",
    "a = np.mean(exameScore,axis=0)\n",
    "pd.DataFrame(data=a.values,index=a.index,columns=['平均分'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "0abae9f9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>平均分</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>学生_1</th>\n",
       "      <td>70.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_2</th>\n",
       "      <td>84.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_3</th>\n",
       "      <td>70.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_4</th>\n",
       "      <td>72.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_5</th>\n",
       "      <td>72.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_6</th>\n",
       "      <td>69.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_7</th>\n",
       "      <td>68.888889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_8</th>\n",
       "      <td>73.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_9</th>\n",
       "      <td>75.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_10</th>\n",
       "      <td>69.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_11</th>\n",
       "      <td>71.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_12</th>\n",
       "      <td>79.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_13</th>\n",
       "      <td>72.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_14</th>\n",
       "      <td>78.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_15</th>\n",
       "      <td>73.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_16</th>\n",
       "      <td>71.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_17</th>\n",
       "      <td>76.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_18</th>\n",
       "      <td>76.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_19</th>\n",
       "      <td>71.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_20</th>\n",
       "      <td>75.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_21</th>\n",
       "      <td>77.888889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_22</th>\n",
       "      <td>75.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_23</th>\n",
       "      <td>77.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_24</th>\n",
       "      <td>77.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_25</th>\n",
       "      <td>73.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_26</th>\n",
       "      <td>75.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_27</th>\n",
       "      <td>71.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_28</th>\n",
       "      <td>77.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_29</th>\n",
       "      <td>71.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_30</th>\n",
       "      <td>81.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_31</th>\n",
       "      <td>78.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_32</th>\n",
       "      <td>71.888889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_33</th>\n",
       "      <td>71.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_34</th>\n",
       "      <td>81.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_35</th>\n",
       "      <td>73.888889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_36</th>\n",
       "      <td>77.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_37</th>\n",
       "      <td>68.888889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_38</th>\n",
       "      <td>72.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_39</th>\n",
       "      <td>75.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_40</th>\n",
       "      <td>76.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_41</th>\n",
       "      <td>65.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_42</th>\n",
       "      <td>68.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_43</th>\n",
       "      <td>80.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_44</th>\n",
       "      <td>85.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_45</th>\n",
       "      <td>83.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_46</th>\n",
       "      <td>69.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_47</th>\n",
       "      <td>76.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_48</th>\n",
       "      <td>70.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_49</th>\n",
       "      <td>66.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_50</th>\n",
       "      <td>66.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_51</th>\n",
       "      <td>75.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_52</th>\n",
       "      <td>73.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_53</th>\n",
       "      <td>83.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_54</th>\n",
       "      <td>67.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_55</th>\n",
       "      <td>72.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_56</th>\n",
       "      <td>78.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_57</th>\n",
       "      <td>62.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_58</th>\n",
       "      <td>78.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_59</th>\n",
       "      <td>68.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生_60</th>\n",
       "      <td>76.555556</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             平均分\n",
       "学生_1   70.444444\n",
       "学生_2   84.777778\n",
       "学生_3   70.111111\n",
       "学生_4   72.444444\n",
       "学生_5   72.666667\n",
       "学生_6   69.444444\n",
       "学生_7   68.888889\n",
       "学生_8   73.222222\n",
       "学生_9   75.000000\n",
       "学生_10  69.555556\n",
       "学生_11  71.555556\n",
       "学生_12  79.000000\n",
       "学生_13  72.444444\n",
       "学生_14  78.666667\n",
       "学生_15  73.777778\n",
       "学生_16  71.111111\n",
       "学生_17  76.777778\n",
       "学生_18  76.666667\n",
       "学生_19  71.333333\n",
       "学生_20  75.777778\n",
       "学生_21  77.888889\n",
       "学生_22  75.555556\n",
       "学生_23  77.000000\n",
       "学生_24  77.777778\n",
       "学生_25  73.555556\n",
       "学生_26  75.222222\n",
       "学生_27  71.222222\n",
       "学生_28  77.111111\n",
       "学生_29  71.000000\n",
       "学生_30  81.111111\n",
       "学生_31  78.666667\n",
       "学生_32  71.888889\n",
       "学生_33  71.444444\n",
       "学生_34  81.555556\n",
       "学生_35  73.888889\n",
       "学生_36  77.777778\n",
       "学生_37  68.888889\n",
       "学生_38  72.222222\n",
       "学生_39  75.444444\n",
       "学生_40  76.666667\n",
       "学生_41  65.555556\n",
       "学生_42  68.666667\n",
       "学生_43  80.444444\n",
       "学生_44  85.111111\n",
       "学生_45  83.222222\n",
       "学生_46  69.444444\n",
       "学生_47  76.444444\n",
       "学生_48  70.555556\n",
       "学生_49  66.777778\n",
       "学生_50  66.777778\n",
       "学生_51  75.222222\n",
       "学生_52  73.777778\n",
       "学生_53  83.777778\n",
       "学生_54  67.222222\n",
       "学生_55  72.222222\n",
       "学生_56  78.444444\n",
       "学生_57  62.333333\n",
       "学生_58  78.222222\n",
       "学生_59  68.555556\n",
       "学生_60  76.555556"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#各同学平均分\n",
    "b=np.mean(exameScore,axis=1)\n",
    "pd.DataFrame(data=b.values,index=b.index,columns=['平均分'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "aeb39eca",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>语文</th>\n",
       "      <th>数学</th>\n",
       "      <th>英语</th>\n",
       "      <th>政治</th>\n",
       "      <th>地理</th>\n",
       "      <th>历史</th>\n",
       "      <th>生物</th>\n",
       "      <th>物理</th>\n",
       "      <th>化学</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>学生-1</th>\n",
       "      <td>85</td>\n",
       "      <td>91</td>\n",
       "      <td>64</td>\n",
       "      <td>89</td>\n",
       "      <td>98</td>\n",
       "      <td>50</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-2</th>\n",
       "      <td>86</td>\n",
       "      <td>88</td>\n",
       "      <td>70</td>\n",
       "      <td>94</td>\n",
       "      <td>95</td>\n",
       "      <td>67</td>\n",
       "      <td>81</td>\n",
       "      <td>92</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-3</th>\n",
       "      <td>74</td>\n",
       "      <td>76</td>\n",
       "      <td>52</td>\n",
       "      <td>67</td>\n",
       "      <td>72</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>75</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-4</th>\n",
       "      <td>92</td>\n",
       "      <td>74</td>\n",
       "      <td>70</td>\n",
       "      <td>62</td>\n",
       "      <td>89</td>\n",
       "      <td>64</td>\n",
       "      <td>59</td>\n",
       "      <td>51</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-5</th>\n",
       "      <td>91</td>\n",
       "      <td>57</td>\n",
       "      <td>79</td>\n",
       "      <td>71</td>\n",
       "      <td>85</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>53</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-6</th>\n",
       "      <td>92</td>\n",
       "      <td>51</td>\n",
       "      <td>61</td>\n",
       "      <td>95</td>\n",
       "      <td>60</td>\n",
       "      <td>68</td>\n",
       "      <td>54</td>\n",
       "      <td>57</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-7</th>\n",
       "      <td>58</td>\n",
       "      <td>54</td>\n",
       "      <td>63</td>\n",
       "      <td>70</td>\n",
       "      <td>83</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "      <td>59</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-8</th>\n",
       "      <td>54</td>\n",
       "      <td>69</td>\n",
       "      <td>61</td>\n",
       "      <td>72</td>\n",
       "      <td>87</td>\n",
       "      <td>95</td>\n",
       "      <td>71</td>\n",
       "      <td>72</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-9</th>\n",
       "      <td>98</td>\n",
       "      <td>55</td>\n",
       "      <td>99</td>\n",
       "      <td>78</td>\n",
       "      <td>67</td>\n",
       "      <td>50</td>\n",
       "      <td>56</td>\n",
       "      <td>89</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-10</th>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>59</td>\n",
       "      <td>88</td>\n",
       "      <td>82</td>\n",
       "      <td>87</td>\n",
       "      <td>61</td>\n",
       "      <td>66</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-11</th>\n",
       "      <td>88</td>\n",
       "      <td>64</td>\n",
       "      <td>63</td>\n",
       "      <td>92</td>\n",
       "      <td>87</td>\n",
       "      <td>51</td>\n",
       "      <td>83</td>\n",
       "      <td>56</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-12</th>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>77</td>\n",
       "      <td>93</td>\n",
       "      <td>78</td>\n",
       "      <td>96</td>\n",
       "      <td>86</td>\n",
       "      <td>85</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-13</th>\n",
       "      <td>76</td>\n",
       "      <td>70</td>\n",
       "      <td>56</td>\n",
       "      <td>82</td>\n",
       "      <td>68</td>\n",
       "      <td>65</td>\n",
       "      <td>87</td>\n",
       "      <td>97</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-14</th>\n",
       "      <td>53</td>\n",
       "      <td>95</td>\n",
       "      <td>53</td>\n",
       "      <td>96</td>\n",
       "      <td>60</td>\n",
       "      <td>93</td>\n",
       "      <td>91</td>\n",
       "      <td>88</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-15</th>\n",
       "      <td>65</td>\n",
       "      <td>67</td>\n",
       "      <td>64</td>\n",
       "      <td>92</td>\n",
       "      <td>75</td>\n",
       "      <td>72</td>\n",
       "      <td>88</td>\n",
       "      <td>54</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-16</th>\n",
       "      <td>50</td>\n",
       "      <td>76</td>\n",
       "      <td>73</td>\n",
       "      <td>78</td>\n",
       "      <td>90</td>\n",
       "      <td>66</td>\n",
       "      <td>76</td>\n",
       "      <td>77</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-17</th>\n",
       "      <td>91</td>\n",
       "      <td>63</td>\n",
       "      <td>81</td>\n",
       "      <td>97</td>\n",
       "      <td>61</td>\n",
       "      <td>83</td>\n",
       "      <td>74</td>\n",
       "      <td>56</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-18</th>\n",
       "      <td>95</td>\n",
       "      <td>88</td>\n",
       "      <td>56</td>\n",
       "      <td>65</td>\n",
       "      <td>59</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>91</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-19</th>\n",
       "      <td>88</td>\n",
       "      <td>69</td>\n",
       "      <td>96</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>53</td>\n",
       "      <td>71</td>\n",
       "      <td>59</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-20</th>\n",
       "      <td>96</td>\n",
       "      <td>66</td>\n",
       "      <td>91</td>\n",
       "      <td>92</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "      <td>59</td>\n",
       "      <td>53</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-21</th>\n",
       "      <td>59</td>\n",
       "      <td>71</td>\n",
       "      <td>86</td>\n",
       "      <td>91</td>\n",
       "      <td>82</td>\n",
       "      <td>97</td>\n",
       "      <td>52</td>\n",
       "      <td>81</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-22</th>\n",
       "      <td>78</td>\n",
       "      <td>55</td>\n",
       "      <td>89</td>\n",
       "      <td>55</td>\n",
       "      <td>79</td>\n",
       "      <td>71</td>\n",
       "      <td>88</td>\n",
       "      <td>82</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-23</th>\n",
       "      <td>92</td>\n",
       "      <td>95</td>\n",
       "      <td>58</td>\n",
       "      <td>84</td>\n",
       "      <td>77</td>\n",
       "      <td>56</td>\n",
       "      <td>64</td>\n",
       "      <td>90</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-24</th>\n",
       "      <td>81</td>\n",
       "      <td>61</td>\n",
       "      <td>97</td>\n",
       "      <td>62</td>\n",
       "      <td>87</td>\n",
       "      <td>69</td>\n",
       "      <td>57</td>\n",
       "      <td>91</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-25</th>\n",
       "      <td>85</td>\n",
       "      <td>72</td>\n",
       "      <td>59</td>\n",
       "      <td>64</td>\n",
       "      <td>79</td>\n",
       "      <td>93</td>\n",
       "      <td>57</td>\n",
       "      <td>57</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-26</th>\n",
       "      <td>83</td>\n",
       "      <td>92</td>\n",
       "      <td>50</td>\n",
       "      <td>57</td>\n",
       "      <td>86</td>\n",
       "      <td>65</td>\n",
       "      <td>84</td>\n",
       "      <td>69</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-27</th>\n",
       "      <td>54</td>\n",
       "      <td>70</td>\n",
       "      <td>52</td>\n",
       "      <td>75</td>\n",
       "      <td>61</td>\n",
       "      <td>87</td>\n",
       "      <td>98</td>\n",
       "      <td>93</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-28</th>\n",
       "      <td>61</td>\n",
       "      <td>84</td>\n",
       "      <td>86</td>\n",
       "      <td>69</td>\n",
       "      <td>87</td>\n",
       "      <td>91</td>\n",
       "      <td>90</td>\n",
       "      <td>57</td>\n",
       "      <td>69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-29</th>\n",
       "      <td>50</td>\n",
       "      <td>71</td>\n",
       "      <td>77</td>\n",
       "      <td>70</td>\n",
       "      <td>95</td>\n",
       "      <td>75</td>\n",
       "      <td>64</td>\n",
       "      <td>56</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-30</th>\n",
       "      <td>79</td>\n",
       "      <td>68</td>\n",
       "      <td>67</td>\n",
       "      <td>70</td>\n",
       "      <td>88</td>\n",
       "      <td>92</td>\n",
       "      <td>79</td>\n",
       "      <td>94</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-31</th>\n",
       "      <td>64</td>\n",
       "      <td>58</td>\n",
       "      <td>92</td>\n",
       "      <td>88</td>\n",
       "      <td>80</td>\n",
       "      <td>98</td>\n",
       "      <td>89</td>\n",
       "      <td>87</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-32</th>\n",
       "      <td>83</td>\n",
       "      <td>51</td>\n",
       "      <td>86</td>\n",
       "      <td>63</td>\n",
       "      <td>56</td>\n",
       "      <td>50</td>\n",
       "      <td>91</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-33</th>\n",
       "      <td>91</td>\n",
       "      <td>82</td>\n",
       "      <td>54</td>\n",
       "      <td>61</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>70</td>\n",
       "      <td>84</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-34</th>\n",
       "      <td>61</td>\n",
       "      <td>98</td>\n",
       "      <td>73</td>\n",
       "      <td>79</td>\n",
       "      <td>92</td>\n",
       "      <td>84</td>\n",
       "      <td>82</td>\n",
       "      <td>76</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-35</th>\n",
       "      <td>54</td>\n",
       "      <td>71</td>\n",
       "      <td>69</td>\n",
       "      <td>92</td>\n",
       "      <td>55</td>\n",
       "      <td>92</td>\n",
       "      <td>58</td>\n",
       "      <td>95</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-36</th>\n",
       "      <td>87</td>\n",
       "      <td>75</td>\n",
       "      <td>78</td>\n",
       "      <td>99</td>\n",
       "      <td>88</td>\n",
       "      <td>64</td>\n",
       "      <td>61</td>\n",
       "      <td>90</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-37</th>\n",
       "      <td>81</td>\n",
       "      <td>73</td>\n",
       "      <td>82</td>\n",
       "      <td>56</td>\n",
       "      <td>69</td>\n",
       "      <td>53</td>\n",
       "      <td>68</td>\n",
       "      <td>78</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-38</th>\n",
       "      <td>52</td>\n",
       "      <td>67</td>\n",
       "      <td>69</td>\n",
       "      <td>92</td>\n",
       "      <td>86</td>\n",
       "      <td>57</td>\n",
       "      <td>84</td>\n",
       "      <td>77</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-39</th>\n",
       "      <td>64</td>\n",
       "      <td>92</td>\n",
       "      <td>87</td>\n",
       "      <td>89</td>\n",
       "      <td>75</td>\n",
       "      <td>69</td>\n",
       "      <td>54</td>\n",
       "      <td>59</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-40</th>\n",
       "      <td>68</td>\n",
       "      <td>93</td>\n",
       "      <td>60</td>\n",
       "      <td>57</td>\n",
       "      <td>61</td>\n",
       "      <td>93</td>\n",
       "      <td>87</td>\n",
       "      <td>92</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-41</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>61</td>\n",
       "      <td>71</td>\n",
       "      <td>66</td>\n",
       "      <td>56</td>\n",
       "      <td>85</td>\n",
       "      <td>67</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-42</th>\n",
       "      <td>91</td>\n",
       "      <td>52</td>\n",
       "      <td>79</td>\n",
       "      <td>58</td>\n",
       "      <td>69</td>\n",
       "      <td>85</td>\n",
       "      <td>72</td>\n",
       "      <td>61</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-43</th>\n",
       "      <td>90</td>\n",
       "      <td>82</td>\n",
       "      <td>69</td>\n",
       "      <td>76</td>\n",
       "      <td>59</td>\n",
       "      <td>91</td>\n",
       "      <td>88</td>\n",
       "      <td>97</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-44</th>\n",
       "      <td>68</td>\n",
       "      <td>98</td>\n",
       "      <td>93</td>\n",
       "      <td>89</td>\n",
       "      <td>76</td>\n",
       "      <td>97</td>\n",
       "      <td>83</td>\n",
       "      <td>96</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-45</th>\n",
       "      <td>81</td>\n",
       "      <td>99</td>\n",
       "      <td>92</td>\n",
       "      <td>96</td>\n",
       "      <td>71</td>\n",
       "      <td>84</td>\n",
       "      <td>74</td>\n",
       "      <td>79</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-46</th>\n",
       "      <td>60</td>\n",
       "      <td>71</td>\n",
       "      <td>62</td>\n",
       "      <td>50</td>\n",
       "      <td>99</td>\n",
       "      <td>58</td>\n",
       "      <td>89</td>\n",
       "      <td>60</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-47</th>\n",
       "      <td>71</td>\n",
       "      <td>64</td>\n",
       "      <td>60</td>\n",
       "      <td>71</td>\n",
       "      <td>99</td>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>92</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-48</th>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>62</td>\n",
       "      <td>82</td>\n",
       "      <td>50</td>\n",
       "      <td>81</td>\n",
       "      <td>83</td>\n",
       "      <td>81</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-49</th>\n",
       "      <td>56</td>\n",
       "      <td>97</td>\n",
       "      <td>57</td>\n",
       "      <td>58</td>\n",
       "      <td>79</td>\n",
       "      <td>65</td>\n",
       "      <td>76</td>\n",
       "      <td>59</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-50</th>\n",
       "      <td>84</td>\n",
       "      <td>83</td>\n",
       "      <td>65</td>\n",
       "      <td>53</td>\n",
       "      <td>54</td>\n",
       "      <td>71</td>\n",
       "      <td>56</td>\n",
       "      <td>74</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-51</th>\n",
       "      <td>59</td>\n",
       "      <td>88</td>\n",
       "      <td>50</td>\n",
       "      <td>94</td>\n",
       "      <td>86</td>\n",
       "      <td>87</td>\n",
       "      <td>60</td>\n",
       "      <td>62</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-52</th>\n",
       "      <td>88</td>\n",
       "      <td>76</td>\n",
       "      <td>92</td>\n",
       "      <td>95</td>\n",
       "      <td>55</td>\n",
       "      <td>87</td>\n",
       "      <td>57</td>\n",
       "      <td>50</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-53</th>\n",
       "      <td>99</td>\n",
       "      <td>94</td>\n",
       "      <td>81</td>\n",
       "      <td>85</td>\n",
       "      <td>91</td>\n",
       "      <td>94</td>\n",
       "      <td>64</td>\n",
       "      <td>92</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-54</th>\n",
       "      <td>82</td>\n",
       "      <td>68</td>\n",
       "      <td>75</td>\n",
       "      <td>54</td>\n",
       "      <td>77</td>\n",
       "      <td>59</td>\n",
       "      <td>50</td>\n",
       "      <td>90</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-55</th>\n",
       "      <td>59</td>\n",
       "      <td>96</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>56</td>\n",
       "      <td>72</td>\n",
       "      <td>84</td>\n",
       "      <td>96</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-56</th>\n",
       "      <td>68</td>\n",
       "      <td>81</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>81</td>\n",
       "      <td>94</td>\n",
       "      <td>93</td>\n",
       "      <td>77</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-57</th>\n",
       "      <td>65</td>\n",
       "      <td>59</td>\n",
       "      <td>53</td>\n",
       "      <td>55</td>\n",
       "      <td>60</td>\n",
       "      <td>66</td>\n",
       "      <td>62</td>\n",
       "      <td>70</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-58</th>\n",
       "      <td>64</td>\n",
       "      <td>77</td>\n",
       "      <td>85</td>\n",
       "      <td>91</td>\n",
       "      <td>50</td>\n",
       "      <td>84</td>\n",
       "      <td>94</td>\n",
       "      <td>98</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-59</th>\n",
       "      <td>63</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>62</td>\n",
       "      <td>81</td>\n",
       "      <td>59</td>\n",
       "      <td>74</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>学生-60</th>\n",
       "      <td>72</td>\n",
       "      <td>74</td>\n",
       "      <td>97</td>\n",
       "      <td>96</td>\n",
       "      <td>74</td>\n",
       "      <td>52</td>\n",
       "      <td>95</td>\n",
       "      <td>73</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       语文  数学  英语  政治  地理  历史  生物  物理  化学\n",
       "学生-1   85  91  64  89  98  50  51  52  54\n",
       "学生-2   86  88  70  94  95  67  81  92  90\n",
       "学生-3   74  76  52  67  72  68  63  75  84\n",
       "学生-4   92  74  70  62  89  64  59  51  91\n",
       "学生-5   91  57  79  71  85  66  66  53  86\n",
       "学生-6   92  51  61  95  60  68  54  57  87\n",
       "学生-7   58  54  63  70  83  85  82  59  66\n",
       "学生-8   54  69  61  72  87  95  71  72  78\n",
       "学生-9   98  55  99  78  67  50  56  89  83\n",
       "学生-10  53  53  59  88  82  87  61  66  77\n",
       "学生-11  88  64  63  92  87  51  83  56  60\n",
       "学生-12  72  70  77  93  78  96  86  85  54\n",
       "学生-13  76  70  56  82  68  65  87  97  51\n",
       "学生-14  53  95  53  96  60  93  91  88  79\n",
       "学生-15  65  67  64  92  75  72  88  54  87\n",
       "学生-16  50  76  73  78  90  66  76  77  54\n",
       "学生-17  91  63  81  97  61  83  74  56  85\n",
       "学生-18  95  88  56  65  59  78  84  91  74\n",
       "学生-19  88  69  96  56  56  53  71  59  94\n",
       "学生-20  96  66  91  92  85  82  59  53  58\n",
       "学生-21  59  71  86  91  82  97  52  81  82\n",
       "学生-22  78  55  89  55  79  71  88  82  83\n",
       "学生-23  92  95  58  84  77  56  64  90  77\n",
       "学生-24  81  61  97  62  87  69  57  91  95\n",
       "学生-25  85  72  59  64  79  93  57  57  96\n",
       "学生-26  83  92  50  57  86  65  84  69  91\n",
       "学生-27  54  70  52  75  61  87  98  93  51\n",
       "学生-28  61  84  86  69  87  91  90  57  69\n",
       "学生-29  50  71  77  70  95  75  64  56  81\n",
       "学生-30  79  68  67  70  88  92  79  94  93\n",
       "学生-31  64  58  92  88  80  98  89  87  52\n",
       "学生-32  83  51  86  63  56  50  91  85  82\n",
       "学生-33  91  82  54  61  51  52  70  84  98\n",
       "学生-34  61  98  73  79  92  84  82  76  89\n",
       "学生-35  54  71  69  92  55  92  58  95  79\n",
       "学生-36  87  75  78  99  88  64  61  90  58\n",
       "学生-37  81  73  82  56  69  53  68  78  60\n",
       "学生-38  52  67  69  92  86  57  84  77  66\n",
       "学生-39  64  92  87  89  75  69  54  59  90\n",
       "学生-40  68  93  60  57  61  93  87  92  79\n",
       "学生-41  50  53  61  71  66  56  85  67  81\n",
       "学生-42  91  52  79  58  69  85  72  61  51\n",
       "学生-43  90  82  69  76  59  91  88  97  72\n",
       "学生-44  68  98  93  89  76  97  83  96  66\n",
       "学生-45  81  99  92  96  71  84  74  79  73\n",
       "学生-46  60  71  62  50  99  58  89  60  76\n",
       "学生-47  71  64  60  71  99  72  70  92  89\n",
       "学生-48  67  73  62  82  50  81  83  81  56\n",
       "学生-49  56  97  57  58  79  65  76  59  54\n",
       "学生-50  84  83  65  53  54  71  56  74  61\n",
       "学生-51  59  88  50  94  86  87  60  62  91\n",
       "学生-52  88  76  92  95  55  87  57  50  64\n",
       "学生-53  99  94  81  85  91  94  64  92  54\n",
       "学生-54  82  68  75  54  77  59  50  90  50\n",
       "学生-55  59  96  68  63  56  72  84  96  56\n",
       "学生-56  68  81  55  65  81  94  93  77  92\n",
       "学生-57  65  59  53  55  60  66  62  70  71\n",
       "学生-58  64  77  85  91  50  84  94  98  61\n",
       "学生-59  63  55  65  90  62  81  59  74  68\n",
       "学生-60  72  74  97  96  74  52  95  73  56"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 修改索引\n",
    "students = ['学生-'+ str(i+1) for i in range(studentCount)]\n",
    "exameScore.index = students\n",
    "exameScore"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "e4dd2dcd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>语文</th>\n",
       "      <th>数学</th>\n",
       "      <th>英语</th>\n",
       "      <th>政治</th>\n",
       "      <th>地理</th>\n",
       "      <th>历史</th>\n",
       "      <th>生物</th>\n",
       "      <th>物理</th>\n",
       "      <th>化学</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>学生-1</td>\n",
       "      <td>85</td>\n",
       "      <td>91</td>\n",
       "      <td>64</td>\n",
       "      <td>89</td>\n",
       "      <td>98</td>\n",
       "      <td>50</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>学生-2</td>\n",
       "      <td>86</td>\n",
       "      <td>88</td>\n",
       "      <td>70</td>\n",
       "      <td>94</td>\n",
       "      <td>95</td>\n",
       "      <td>67</td>\n",
       "      <td>81</td>\n",
       "      <td>92</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>学生-3</td>\n",
       "      <td>74</td>\n",
       "      <td>76</td>\n",
       "      <td>52</td>\n",
       "      <td>67</td>\n",
       "      <td>72</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>75</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>学生-4</td>\n",
       "      <td>92</td>\n",
       "      <td>74</td>\n",
       "      <td>70</td>\n",
       "      <td>62</td>\n",
       "      <td>89</td>\n",
       "      <td>64</td>\n",
       "      <td>59</td>\n",
       "      <td>51</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>学生-5</td>\n",
       "      <td>91</td>\n",
       "      <td>57</td>\n",
       "      <td>79</td>\n",
       "      <td>71</td>\n",
       "      <td>85</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>53</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>学生-6</td>\n",
       "      <td>92</td>\n",
       "      <td>51</td>\n",
       "      <td>61</td>\n",
       "      <td>95</td>\n",
       "      <td>60</td>\n",
       "      <td>68</td>\n",
       "      <td>54</td>\n",
       "      <td>57</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>学生-7</td>\n",
       "      <td>58</td>\n",
       "      <td>54</td>\n",
       "      <td>63</td>\n",
       "      <td>70</td>\n",
       "      <td>83</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "      <td>59</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>学生-8</td>\n",
       "      <td>54</td>\n",
       "      <td>69</td>\n",
       "      <td>61</td>\n",
       "      <td>72</td>\n",
       "      <td>87</td>\n",
       "      <td>95</td>\n",
       "      <td>71</td>\n",
       "      <td>72</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>学生-9</td>\n",
       "      <td>98</td>\n",
       "      <td>55</td>\n",
       "      <td>99</td>\n",
       "      <td>78</td>\n",
       "      <td>67</td>\n",
       "      <td>50</td>\n",
       "      <td>56</td>\n",
       "      <td>89</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>学生-10</td>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>59</td>\n",
       "      <td>88</td>\n",
       "      <td>82</td>\n",
       "      <td>87</td>\n",
       "      <td>61</td>\n",
       "      <td>66</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>学生-11</td>\n",
       "      <td>88</td>\n",
       "      <td>64</td>\n",
       "      <td>63</td>\n",
       "      <td>92</td>\n",
       "      <td>87</td>\n",
       "      <td>51</td>\n",
       "      <td>83</td>\n",
       "      <td>56</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>学生-12</td>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>77</td>\n",
       "      <td>93</td>\n",
       "      <td>78</td>\n",
       "      <td>96</td>\n",
       "      <td>86</td>\n",
       "      <td>85</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>学生-13</td>\n",
       "      <td>76</td>\n",
       "      <td>70</td>\n",
       "      <td>56</td>\n",
       "      <td>82</td>\n",
       "      <td>68</td>\n",
       "      <td>65</td>\n",
       "      <td>87</td>\n",
       "      <td>97</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>学生-14</td>\n",
       "      <td>53</td>\n",
       "      <td>95</td>\n",
       "      <td>53</td>\n",
       "      <td>96</td>\n",
       "      <td>60</td>\n",
       "      <td>93</td>\n",
       "      <td>91</td>\n",
       "      <td>88</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>学生-15</td>\n",
       "      <td>65</td>\n",
       "      <td>67</td>\n",
       "      <td>64</td>\n",
       "      <td>92</td>\n",
       "      <td>75</td>\n",
       "      <td>72</td>\n",
       "      <td>88</td>\n",
       "      <td>54</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>学生-16</td>\n",
       "      <td>50</td>\n",
       "      <td>76</td>\n",
       "      <td>73</td>\n",
       "      <td>78</td>\n",
       "      <td>90</td>\n",
       "      <td>66</td>\n",
       "      <td>76</td>\n",
       "      <td>77</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>学生-17</td>\n",
       "      <td>91</td>\n",
       "      <td>63</td>\n",
       "      <td>81</td>\n",
       "      <td>97</td>\n",
       "      <td>61</td>\n",
       "      <td>83</td>\n",
       "      <td>74</td>\n",
       "      <td>56</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>学生-18</td>\n",
       "      <td>95</td>\n",
       "      <td>88</td>\n",
       "      <td>56</td>\n",
       "      <td>65</td>\n",
       "      <td>59</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>91</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>学生-19</td>\n",
       "      <td>88</td>\n",
       "      <td>69</td>\n",
       "      <td>96</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>53</td>\n",
       "      <td>71</td>\n",
       "      <td>59</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>学生-20</td>\n",
       "      <td>96</td>\n",
       "      <td>66</td>\n",
       "      <td>91</td>\n",
       "      <td>92</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "      <td>59</td>\n",
       "      <td>53</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>学生-21</td>\n",
       "      <td>59</td>\n",
       "      <td>71</td>\n",
       "      <td>86</td>\n",
       "      <td>91</td>\n",
       "      <td>82</td>\n",
       "      <td>97</td>\n",
       "      <td>52</td>\n",
       "      <td>81</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>学生-22</td>\n",
       "      <td>78</td>\n",
       "      <td>55</td>\n",
       "      <td>89</td>\n",
       "      <td>55</td>\n",
       "      <td>79</td>\n",
       "      <td>71</td>\n",
       "      <td>88</td>\n",
       "      <td>82</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>学生-23</td>\n",
       "      <td>92</td>\n",
       "      <td>95</td>\n",
       "      <td>58</td>\n",
       "      <td>84</td>\n",
       "      <td>77</td>\n",
       "      <td>56</td>\n",
       "      <td>64</td>\n",
       "      <td>90</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>学生-24</td>\n",
       "      <td>81</td>\n",
       "      <td>61</td>\n",
       "      <td>97</td>\n",
       "      <td>62</td>\n",
       "      <td>87</td>\n",
       "      <td>69</td>\n",
       "      <td>57</td>\n",
       "      <td>91</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>学生-25</td>\n",
       "      <td>85</td>\n",
       "      <td>72</td>\n",
       "      <td>59</td>\n",
       "      <td>64</td>\n",
       "      <td>79</td>\n",
       "      <td>93</td>\n",
       "      <td>57</td>\n",
       "      <td>57</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>学生-26</td>\n",
       "      <td>83</td>\n",
       "      <td>92</td>\n",
       "      <td>50</td>\n",
       "      <td>57</td>\n",
       "      <td>86</td>\n",
       "      <td>65</td>\n",
       "      <td>84</td>\n",
       "      <td>69</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>学生-27</td>\n",
       "      <td>54</td>\n",
       "      <td>70</td>\n",
       "      <td>52</td>\n",
       "      <td>75</td>\n",
       "      <td>61</td>\n",
       "      <td>87</td>\n",
       "      <td>98</td>\n",
       "      <td>93</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>学生-28</td>\n",
       "      <td>61</td>\n",
       "      <td>84</td>\n",
       "      <td>86</td>\n",
       "      <td>69</td>\n",
       "      <td>87</td>\n",
       "      <td>91</td>\n",
       "      <td>90</td>\n",
       "      <td>57</td>\n",
       "      <td>69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>学生-29</td>\n",
       "      <td>50</td>\n",
       "      <td>71</td>\n",
       "      <td>77</td>\n",
       "      <td>70</td>\n",
       "      <td>95</td>\n",
       "      <td>75</td>\n",
       "      <td>64</td>\n",
       "      <td>56</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>学生-30</td>\n",
       "      <td>79</td>\n",
       "      <td>68</td>\n",
       "      <td>67</td>\n",
       "      <td>70</td>\n",
       "      <td>88</td>\n",
       "      <td>92</td>\n",
       "      <td>79</td>\n",
       "      <td>94</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>学生-31</td>\n",
       "      <td>64</td>\n",
       "      <td>58</td>\n",
       "      <td>92</td>\n",
       "      <td>88</td>\n",
       "      <td>80</td>\n",
       "      <td>98</td>\n",
       "      <td>89</td>\n",
       "      <td>87</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>学生-32</td>\n",
       "      <td>83</td>\n",
       "      <td>51</td>\n",
       "      <td>86</td>\n",
       "      <td>63</td>\n",
       "      <td>56</td>\n",
       "      <td>50</td>\n",
       "      <td>91</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>学生-33</td>\n",
       "      <td>91</td>\n",
       "      <td>82</td>\n",
       "      <td>54</td>\n",
       "      <td>61</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>70</td>\n",
       "      <td>84</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>学生-34</td>\n",
       "      <td>61</td>\n",
       "      <td>98</td>\n",
       "      <td>73</td>\n",
       "      <td>79</td>\n",
       "      <td>92</td>\n",
       "      <td>84</td>\n",
       "      <td>82</td>\n",
       "      <td>76</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>学生-35</td>\n",
       "      <td>54</td>\n",
       "      <td>71</td>\n",
       "      <td>69</td>\n",
       "      <td>92</td>\n",
       "      <td>55</td>\n",
       "      <td>92</td>\n",
       "      <td>58</td>\n",
       "      <td>95</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>学生-36</td>\n",
       "      <td>87</td>\n",
       "      <td>75</td>\n",
       "      <td>78</td>\n",
       "      <td>99</td>\n",
       "      <td>88</td>\n",
       "      <td>64</td>\n",
       "      <td>61</td>\n",
       "      <td>90</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>学生-37</td>\n",
       "      <td>81</td>\n",
       "      <td>73</td>\n",
       "      <td>82</td>\n",
       "      <td>56</td>\n",
       "      <td>69</td>\n",
       "      <td>53</td>\n",
       "      <td>68</td>\n",
       "      <td>78</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>学生-38</td>\n",
       "      <td>52</td>\n",
       "      <td>67</td>\n",
       "      <td>69</td>\n",
       "      <td>92</td>\n",
       "      <td>86</td>\n",
       "      <td>57</td>\n",
       "      <td>84</td>\n",
       "      <td>77</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>学生-39</td>\n",
       "      <td>64</td>\n",
       "      <td>92</td>\n",
       "      <td>87</td>\n",
       "      <td>89</td>\n",
       "      <td>75</td>\n",
       "      <td>69</td>\n",
       "      <td>54</td>\n",
       "      <td>59</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>学生-40</td>\n",
       "      <td>68</td>\n",
       "      <td>93</td>\n",
       "      <td>60</td>\n",
       "      <td>57</td>\n",
       "      <td>61</td>\n",
       "      <td>93</td>\n",
       "      <td>87</td>\n",
       "      <td>92</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>学生-41</td>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>61</td>\n",
       "      <td>71</td>\n",
       "      <td>66</td>\n",
       "      <td>56</td>\n",
       "      <td>85</td>\n",
       "      <td>67</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>学生-42</td>\n",
       "      <td>91</td>\n",
       "      <td>52</td>\n",
       "      <td>79</td>\n",
       "      <td>58</td>\n",
       "      <td>69</td>\n",
       "      <td>85</td>\n",
       "      <td>72</td>\n",
       "      <td>61</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>学生-43</td>\n",
       "      <td>90</td>\n",
       "      <td>82</td>\n",
       "      <td>69</td>\n",
       "      <td>76</td>\n",
       "      <td>59</td>\n",
       "      <td>91</td>\n",
       "      <td>88</td>\n",
       "      <td>97</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>学生-44</td>\n",
       "      <td>68</td>\n",
       "      <td>98</td>\n",
       "      <td>93</td>\n",
       "      <td>89</td>\n",
       "      <td>76</td>\n",
       "      <td>97</td>\n",
       "      <td>83</td>\n",
       "      <td>96</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>学生-45</td>\n",
       "      <td>81</td>\n",
       "      <td>99</td>\n",
       "      <td>92</td>\n",
       "      <td>96</td>\n",
       "      <td>71</td>\n",
       "      <td>84</td>\n",
       "      <td>74</td>\n",
       "      <td>79</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>学生-46</td>\n",
       "      <td>60</td>\n",
       "      <td>71</td>\n",
       "      <td>62</td>\n",
       "      <td>50</td>\n",
       "      <td>99</td>\n",
       "      <td>58</td>\n",
       "      <td>89</td>\n",
       "      <td>60</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>学生-47</td>\n",
       "      <td>71</td>\n",
       "      <td>64</td>\n",
       "      <td>60</td>\n",
       "      <td>71</td>\n",
       "      <td>99</td>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>92</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>学生-48</td>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>62</td>\n",
       "      <td>82</td>\n",
       "      <td>50</td>\n",
       "      <td>81</td>\n",
       "      <td>83</td>\n",
       "      <td>81</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>学生-49</td>\n",
       "      <td>56</td>\n",
       "      <td>97</td>\n",
       "      <td>57</td>\n",
       "      <td>58</td>\n",
       "      <td>79</td>\n",
       "      <td>65</td>\n",
       "      <td>76</td>\n",
       "      <td>59</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>学生-50</td>\n",
       "      <td>84</td>\n",
       "      <td>83</td>\n",
       "      <td>65</td>\n",
       "      <td>53</td>\n",
       "      <td>54</td>\n",
       "      <td>71</td>\n",
       "      <td>56</td>\n",
       "      <td>74</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>学生-51</td>\n",
       "      <td>59</td>\n",
       "      <td>88</td>\n",
       "      <td>50</td>\n",
       "      <td>94</td>\n",
       "      <td>86</td>\n",
       "      <td>87</td>\n",
       "      <td>60</td>\n",
       "      <td>62</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>学生-52</td>\n",
       "      <td>88</td>\n",
       "      <td>76</td>\n",
       "      <td>92</td>\n",
       "      <td>95</td>\n",
       "      <td>55</td>\n",
       "      <td>87</td>\n",
       "      <td>57</td>\n",
       "      <td>50</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>学生-53</td>\n",
       "      <td>99</td>\n",
       "      <td>94</td>\n",
       "      <td>81</td>\n",
       "      <td>85</td>\n",
       "      <td>91</td>\n",
       "      <td>94</td>\n",
       "      <td>64</td>\n",
       "      <td>92</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>学生-54</td>\n",
       "      <td>82</td>\n",
       "      <td>68</td>\n",
       "      <td>75</td>\n",
       "      <td>54</td>\n",
       "      <td>77</td>\n",
       "      <td>59</td>\n",
       "      <td>50</td>\n",
       "      <td>90</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>学生-55</td>\n",
       "      <td>59</td>\n",
       "      <td>96</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>56</td>\n",
       "      <td>72</td>\n",
       "      <td>84</td>\n",
       "      <td>96</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>学生-56</td>\n",
       "      <td>68</td>\n",
       "      <td>81</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>81</td>\n",
       "      <td>94</td>\n",
       "      <td>93</td>\n",
       "      <td>77</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>学生-57</td>\n",
       "      <td>65</td>\n",
       "      <td>59</td>\n",
       "      <td>53</td>\n",
       "      <td>55</td>\n",
       "      <td>60</td>\n",
       "      <td>66</td>\n",
       "      <td>62</td>\n",
       "      <td>70</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>学生-58</td>\n",
       "      <td>64</td>\n",
       "      <td>77</td>\n",
       "      <td>85</td>\n",
       "      <td>91</td>\n",
       "      <td>50</td>\n",
       "      <td>84</td>\n",
       "      <td>94</td>\n",
       "      <td>98</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>学生-59</td>\n",
       "      <td>63</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>62</td>\n",
       "      <td>81</td>\n",
       "      <td>59</td>\n",
       "      <td>74</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>学生-60</td>\n",
       "      <td>72</td>\n",
       "      <td>74</td>\n",
       "      <td>97</td>\n",
       "      <td>96</td>\n",
       "      <td>74</td>\n",
       "      <td>52</td>\n",
       "      <td>95</td>\n",
       "      <td>73</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    index  语文  数学  英语  政治  地理  历史  生物  物理  化学\n",
       "0    学生-1  85  91  64  89  98  50  51  52  54\n",
       "1    学生-2  86  88  70  94  95  67  81  92  90\n",
       "2    学生-3  74  76  52  67  72  68  63  75  84\n",
       "3    学生-4  92  74  70  62  89  64  59  51  91\n",
       "4    学生-5  91  57  79  71  85  66  66  53  86\n",
       "5    学生-6  92  51  61  95  60  68  54  57  87\n",
       "6    学生-7  58  54  63  70  83  85  82  59  66\n",
       "7    学生-8  54  69  61  72  87  95  71  72  78\n",
       "8    学生-9  98  55  99  78  67  50  56  89  83\n",
       "9   学生-10  53  53  59  88  82  87  61  66  77\n",
       "10  学生-11  88  64  63  92  87  51  83  56  60\n",
       "11  学生-12  72  70  77  93  78  96  86  85  54\n",
       "12  学生-13  76  70  56  82  68  65  87  97  51\n",
       "13  学生-14  53  95  53  96  60  93  91  88  79\n",
       "14  学生-15  65  67  64  92  75  72  88  54  87\n",
       "15  学生-16  50  76  73  78  90  66  76  77  54\n",
       "16  学生-17  91  63  81  97  61  83  74  56  85\n",
       "17  学生-18  95  88  56  65  59  78  84  91  74\n",
       "18  学生-19  88  69  96  56  56  53  71  59  94\n",
       "19  学生-20  96  66  91  92  85  82  59  53  58\n",
       "20  学生-21  59  71  86  91  82  97  52  81  82\n",
       "21  学生-22  78  55  89  55  79  71  88  82  83\n",
       "22  学生-23  92  95  58  84  77  56  64  90  77\n",
       "23  学生-24  81  61  97  62  87  69  57  91  95\n",
       "24  学生-25  85  72  59  64  79  93  57  57  96\n",
       "25  学生-26  83  92  50  57  86  65  84  69  91\n",
       "26  学生-27  54  70  52  75  61  87  98  93  51\n",
       "27  学生-28  61  84  86  69  87  91  90  57  69\n",
       "28  学生-29  50  71  77  70  95  75  64  56  81\n",
       "29  学生-30  79  68  67  70  88  92  79  94  93\n",
       "30  学生-31  64  58  92  88  80  98  89  87  52\n",
       "31  学生-32  83  51  86  63  56  50  91  85  82\n",
       "32  学生-33  91  82  54  61  51  52  70  84  98\n",
       "33  学生-34  61  98  73  79  92  84  82  76  89\n",
       "34  学生-35  54  71  69  92  55  92  58  95  79\n",
       "35  学生-36  87  75  78  99  88  64  61  90  58\n",
       "36  学生-37  81  73  82  56  69  53  68  78  60\n",
       "37  学生-38  52  67  69  92  86  57  84  77  66\n",
       "38  学生-39  64  92  87  89  75  69  54  59  90\n",
       "39  学生-40  68  93  60  57  61  93  87  92  79\n",
       "40  学生-41  50  53  61  71  66  56  85  67  81\n",
       "41  学生-42  91  52  79  58  69  85  72  61  51\n",
       "42  学生-43  90  82  69  76  59  91  88  97  72\n",
       "43  学生-44  68  98  93  89  76  97  83  96  66\n",
       "44  学生-45  81  99  92  96  71  84  74  79  73\n",
       "45  学生-46  60  71  62  50  99  58  89  60  76\n",
       "46  学生-47  71  64  60  71  99  72  70  92  89\n",
       "47  学生-48  67  73  62  82  50  81  83  81  56\n",
       "48  学生-49  56  97  57  58  79  65  76  59  54\n",
       "49  学生-50  84  83  65  53  54  71  56  74  61\n",
       "50  学生-51  59  88  50  94  86  87  60  62  91\n",
       "51  学生-52  88  76  92  95  55  87  57  50  64\n",
       "52  学生-53  99  94  81  85  91  94  64  92  54\n",
       "53  学生-54  82  68  75  54  77  59  50  90  50\n",
       "54  学生-55  59  96  68  63  56  72  84  96  56\n",
       "55  学生-56  68  81  55  65  81  94  93  77  92\n",
       "56  学生-57  65  59  53  55  60  66  62  70  71\n",
       "57  学生-58  64  77  85  91  50  84  94  98  61\n",
       "58  学生-59  63  55  65  90  62  81  59  74  68\n",
       "59  学生-60  72  74  97  96  74  52  95  73  56"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 重写索引\n",
    "exameScore.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "aa6eb4ea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>语文</th>\n",
       "      <th>数学</th>\n",
       "      <th>英语</th>\n",
       "      <th>政治</th>\n",
       "      <th>地理</th>\n",
       "      <th>历史</th>\n",
       "      <th>生物</th>\n",
       "      <th>物理</th>\n",
       "      <th>化学</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>85</td>\n",
       "      <td>91</td>\n",
       "      <td>64</td>\n",
       "      <td>89</td>\n",
       "      <td>98</td>\n",
       "      <td>50</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>86</td>\n",
       "      <td>88</td>\n",
       "      <td>70</td>\n",
       "      <td>94</td>\n",
       "      <td>95</td>\n",
       "      <td>67</td>\n",
       "      <td>81</td>\n",
       "      <td>92</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>74</td>\n",
       "      <td>76</td>\n",
       "      <td>52</td>\n",
       "      <td>67</td>\n",
       "      <td>72</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>75</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>92</td>\n",
       "      <td>74</td>\n",
       "      <td>70</td>\n",
       "      <td>62</td>\n",
       "      <td>89</td>\n",
       "      <td>64</td>\n",
       "      <td>59</td>\n",
       "      <td>51</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>91</td>\n",
       "      <td>57</td>\n",
       "      <td>79</td>\n",
       "      <td>71</td>\n",
       "      <td>85</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>53</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>92</td>\n",
       "      <td>51</td>\n",
       "      <td>61</td>\n",
       "      <td>95</td>\n",
       "      <td>60</td>\n",
       "      <td>68</td>\n",
       "      <td>54</td>\n",
       "      <td>57</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>58</td>\n",
       "      <td>54</td>\n",
       "      <td>63</td>\n",
       "      <td>70</td>\n",
       "      <td>83</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "      <td>59</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>54</td>\n",
       "      <td>69</td>\n",
       "      <td>61</td>\n",
       "      <td>72</td>\n",
       "      <td>87</td>\n",
       "      <td>95</td>\n",
       "      <td>71</td>\n",
       "      <td>72</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>98</td>\n",
       "      <td>55</td>\n",
       "      <td>99</td>\n",
       "      <td>78</td>\n",
       "      <td>67</td>\n",
       "      <td>50</td>\n",
       "      <td>56</td>\n",
       "      <td>89</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>59</td>\n",
       "      <td>88</td>\n",
       "      <td>82</td>\n",
       "      <td>87</td>\n",
       "      <td>61</td>\n",
       "      <td>66</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>88</td>\n",
       "      <td>64</td>\n",
       "      <td>63</td>\n",
       "      <td>92</td>\n",
       "      <td>87</td>\n",
       "      <td>51</td>\n",
       "      <td>83</td>\n",
       "      <td>56</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>77</td>\n",
       "      <td>93</td>\n",
       "      <td>78</td>\n",
       "      <td>96</td>\n",
       "      <td>86</td>\n",
       "      <td>85</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>76</td>\n",
       "      <td>70</td>\n",
       "      <td>56</td>\n",
       "      <td>82</td>\n",
       "      <td>68</td>\n",
       "      <td>65</td>\n",
       "      <td>87</td>\n",
       "      <td>97</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>53</td>\n",
       "      <td>95</td>\n",
       "      <td>53</td>\n",
       "      <td>96</td>\n",
       "      <td>60</td>\n",
       "      <td>93</td>\n",
       "      <td>91</td>\n",
       "      <td>88</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>65</td>\n",
       "      <td>67</td>\n",
       "      <td>64</td>\n",
       "      <td>92</td>\n",
       "      <td>75</td>\n",
       "      <td>72</td>\n",
       "      <td>88</td>\n",
       "      <td>54</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>50</td>\n",
       "      <td>76</td>\n",
       "      <td>73</td>\n",
       "      <td>78</td>\n",
       "      <td>90</td>\n",
       "      <td>66</td>\n",
       "      <td>76</td>\n",
       "      <td>77</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>91</td>\n",
       "      <td>63</td>\n",
       "      <td>81</td>\n",
       "      <td>97</td>\n",
       "      <td>61</td>\n",
       "      <td>83</td>\n",
       "      <td>74</td>\n",
       "      <td>56</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>95</td>\n",
       "      <td>88</td>\n",
       "      <td>56</td>\n",
       "      <td>65</td>\n",
       "      <td>59</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>91</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>88</td>\n",
       "      <td>69</td>\n",
       "      <td>96</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>53</td>\n",
       "      <td>71</td>\n",
       "      <td>59</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>96</td>\n",
       "      <td>66</td>\n",
       "      <td>91</td>\n",
       "      <td>92</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "      <td>59</td>\n",
       "      <td>53</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>59</td>\n",
       "      <td>71</td>\n",
       "      <td>86</td>\n",
       "      <td>91</td>\n",
       "      <td>82</td>\n",
       "      <td>97</td>\n",
       "      <td>52</td>\n",
       "      <td>81</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>78</td>\n",
       "      <td>55</td>\n",
       "      <td>89</td>\n",
       "      <td>55</td>\n",
       "      <td>79</td>\n",
       "      <td>71</td>\n",
       "      <td>88</td>\n",
       "      <td>82</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>92</td>\n",
       "      <td>95</td>\n",
       "      <td>58</td>\n",
       "      <td>84</td>\n",
       "      <td>77</td>\n",
       "      <td>56</td>\n",
       "      <td>64</td>\n",
       "      <td>90</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>81</td>\n",
       "      <td>61</td>\n",
       "      <td>97</td>\n",
       "      <td>62</td>\n",
       "      <td>87</td>\n",
       "      <td>69</td>\n",
       "      <td>57</td>\n",
       "      <td>91</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>85</td>\n",
       "      <td>72</td>\n",
       "      <td>59</td>\n",
       "      <td>64</td>\n",
       "      <td>79</td>\n",
       "      <td>93</td>\n",
       "      <td>57</td>\n",
       "      <td>57</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>83</td>\n",
       "      <td>92</td>\n",
       "      <td>50</td>\n",
       "      <td>57</td>\n",
       "      <td>86</td>\n",
       "      <td>65</td>\n",
       "      <td>84</td>\n",
       "      <td>69</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>54</td>\n",
       "      <td>70</td>\n",
       "      <td>52</td>\n",
       "      <td>75</td>\n",
       "      <td>61</td>\n",
       "      <td>87</td>\n",
       "      <td>98</td>\n",
       "      <td>93</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>61</td>\n",
       "      <td>84</td>\n",
       "      <td>86</td>\n",
       "      <td>69</td>\n",
       "      <td>87</td>\n",
       "      <td>91</td>\n",
       "      <td>90</td>\n",
       "      <td>57</td>\n",
       "      <td>69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>50</td>\n",
       "      <td>71</td>\n",
       "      <td>77</td>\n",
       "      <td>70</td>\n",
       "      <td>95</td>\n",
       "      <td>75</td>\n",
       "      <td>64</td>\n",
       "      <td>56</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>79</td>\n",
       "      <td>68</td>\n",
       "      <td>67</td>\n",
       "      <td>70</td>\n",
       "      <td>88</td>\n",
       "      <td>92</td>\n",
       "      <td>79</td>\n",
       "      <td>94</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>64</td>\n",
       "      <td>58</td>\n",
       "      <td>92</td>\n",
       "      <td>88</td>\n",
       "      <td>80</td>\n",
       "      <td>98</td>\n",
       "      <td>89</td>\n",
       "      <td>87</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>83</td>\n",
       "      <td>51</td>\n",
       "      <td>86</td>\n",
       "      <td>63</td>\n",
       "      <td>56</td>\n",
       "      <td>50</td>\n",
       "      <td>91</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>91</td>\n",
       "      <td>82</td>\n",
       "      <td>54</td>\n",
       "      <td>61</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>70</td>\n",
       "      <td>84</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>61</td>\n",
       "      <td>98</td>\n",
       "      <td>73</td>\n",
       "      <td>79</td>\n",
       "      <td>92</td>\n",
       "      <td>84</td>\n",
       "      <td>82</td>\n",
       "      <td>76</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>54</td>\n",
       "      <td>71</td>\n",
       "      <td>69</td>\n",
       "      <td>92</td>\n",
       "      <td>55</td>\n",
       "      <td>92</td>\n",
       "      <td>58</td>\n",
       "      <td>95</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>87</td>\n",
       "      <td>75</td>\n",
       "      <td>78</td>\n",
       "      <td>99</td>\n",
       "      <td>88</td>\n",
       "      <td>64</td>\n",
       "      <td>61</td>\n",
       "      <td>90</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>81</td>\n",
       "      <td>73</td>\n",
       "      <td>82</td>\n",
       "      <td>56</td>\n",
       "      <td>69</td>\n",
       "      <td>53</td>\n",
       "      <td>68</td>\n",
       "      <td>78</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>52</td>\n",
       "      <td>67</td>\n",
       "      <td>69</td>\n",
       "      <td>92</td>\n",
       "      <td>86</td>\n",
       "      <td>57</td>\n",
       "      <td>84</td>\n",
       "      <td>77</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>64</td>\n",
       "      <td>92</td>\n",
       "      <td>87</td>\n",
       "      <td>89</td>\n",
       "      <td>75</td>\n",
       "      <td>69</td>\n",
       "      <td>54</td>\n",
       "      <td>59</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>68</td>\n",
       "      <td>93</td>\n",
       "      <td>60</td>\n",
       "      <td>57</td>\n",
       "      <td>61</td>\n",
       "      <td>93</td>\n",
       "      <td>87</td>\n",
       "      <td>92</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>61</td>\n",
       "      <td>71</td>\n",
       "      <td>66</td>\n",
       "      <td>56</td>\n",
       "      <td>85</td>\n",
       "      <td>67</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>91</td>\n",
       "      <td>52</td>\n",
       "      <td>79</td>\n",
       "      <td>58</td>\n",
       "      <td>69</td>\n",
       "      <td>85</td>\n",
       "      <td>72</td>\n",
       "      <td>61</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>90</td>\n",
       "      <td>82</td>\n",
       "      <td>69</td>\n",
       "      <td>76</td>\n",
       "      <td>59</td>\n",
       "      <td>91</td>\n",
       "      <td>88</td>\n",
       "      <td>97</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>68</td>\n",
       "      <td>98</td>\n",
       "      <td>93</td>\n",
       "      <td>89</td>\n",
       "      <td>76</td>\n",
       "      <td>97</td>\n",
       "      <td>83</td>\n",
       "      <td>96</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>81</td>\n",
       "      <td>99</td>\n",
       "      <td>92</td>\n",
       "      <td>96</td>\n",
       "      <td>71</td>\n",
       "      <td>84</td>\n",
       "      <td>74</td>\n",
       "      <td>79</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>60</td>\n",
       "      <td>71</td>\n",
       "      <td>62</td>\n",
       "      <td>50</td>\n",
       "      <td>99</td>\n",
       "      <td>58</td>\n",
       "      <td>89</td>\n",
       "      <td>60</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>71</td>\n",
       "      <td>64</td>\n",
       "      <td>60</td>\n",
       "      <td>71</td>\n",
       "      <td>99</td>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>92</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>67</td>\n",
       "      <td>73</td>\n",
       "      <td>62</td>\n",
       "      <td>82</td>\n",
       "      <td>50</td>\n",
       "      <td>81</td>\n",
       "      <td>83</td>\n",
       "      <td>81</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>56</td>\n",
       "      <td>97</td>\n",
       "      <td>57</td>\n",
       "      <td>58</td>\n",
       "      <td>79</td>\n",
       "      <td>65</td>\n",
       "      <td>76</td>\n",
       "      <td>59</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>84</td>\n",
       "      <td>83</td>\n",
       "      <td>65</td>\n",
       "      <td>53</td>\n",
       "      <td>54</td>\n",
       "      <td>71</td>\n",
       "      <td>56</td>\n",
       "      <td>74</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>59</td>\n",
       "      <td>88</td>\n",
       "      <td>50</td>\n",
       "      <td>94</td>\n",
       "      <td>86</td>\n",
       "      <td>87</td>\n",
       "      <td>60</td>\n",
       "      <td>62</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>88</td>\n",
       "      <td>76</td>\n",
       "      <td>92</td>\n",
       "      <td>95</td>\n",
       "      <td>55</td>\n",
       "      <td>87</td>\n",
       "      <td>57</td>\n",
       "      <td>50</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>99</td>\n",
       "      <td>94</td>\n",
       "      <td>81</td>\n",
       "      <td>85</td>\n",
       "      <td>91</td>\n",
       "      <td>94</td>\n",
       "      <td>64</td>\n",
       "      <td>92</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>82</td>\n",
       "      <td>68</td>\n",
       "      <td>75</td>\n",
       "      <td>54</td>\n",
       "      <td>77</td>\n",
       "      <td>59</td>\n",
       "      <td>50</td>\n",
       "      <td>90</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>59</td>\n",
       "      <td>96</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>56</td>\n",
       "      <td>72</td>\n",
       "      <td>84</td>\n",
       "      <td>96</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>68</td>\n",
       "      <td>81</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>81</td>\n",
       "      <td>94</td>\n",
       "      <td>93</td>\n",
       "      <td>77</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>65</td>\n",
       "      <td>59</td>\n",
       "      <td>53</td>\n",
       "      <td>55</td>\n",
       "      <td>60</td>\n",
       "      <td>66</td>\n",
       "      <td>62</td>\n",
       "      <td>70</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>64</td>\n",
       "      <td>77</td>\n",
       "      <td>85</td>\n",
       "      <td>91</td>\n",
       "      <td>50</td>\n",
       "      <td>84</td>\n",
       "      <td>94</td>\n",
       "      <td>98</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>63</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>62</td>\n",
       "      <td>81</td>\n",
       "      <td>59</td>\n",
       "      <td>74</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>72</td>\n",
       "      <td>74</td>\n",
       "      <td>97</td>\n",
       "      <td>96</td>\n",
       "      <td>74</td>\n",
       "      <td>52</td>\n",
       "      <td>95</td>\n",
       "      <td>73</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    语文  数学  英语  政治  地理  历史  生物  物理  化学\n",
       "0   85  91  64  89  98  50  51  52  54\n",
       "1   86  88  70  94  95  67  81  92  90\n",
       "2   74  76  52  67  72  68  63  75  84\n",
       "3   92  74  70  62  89  64  59  51  91\n",
       "4   91  57  79  71  85  66  66  53  86\n",
       "5   92  51  61  95  60  68  54  57  87\n",
       "6   58  54  63  70  83  85  82  59  66\n",
       "7   54  69  61  72  87  95  71  72  78\n",
       "8   98  55  99  78  67  50  56  89  83\n",
       "9   53  53  59  88  82  87  61  66  77\n",
       "10  88  64  63  92  87  51  83  56  60\n",
       "11  72  70  77  93  78  96  86  85  54\n",
       "12  76  70  56  82  68  65  87  97  51\n",
       "13  53  95  53  96  60  93  91  88  79\n",
       "14  65  67  64  92  75  72  88  54  87\n",
       "15  50  76  73  78  90  66  76  77  54\n",
       "16  91  63  81  97  61  83  74  56  85\n",
       "17  95  88  56  65  59  78  84  91  74\n",
       "18  88  69  96  56  56  53  71  59  94\n",
       "19  96  66  91  92  85  82  59  53  58\n",
       "20  59  71  86  91  82  97  52  81  82\n",
       "21  78  55  89  55  79  71  88  82  83\n",
       "22  92  95  58  84  77  56  64  90  77\n",
       "23  81  61  97  62  87  69  57  91  95\n",
       "24  85  72  59  64  79  93  57  57  96\n",
       "25  83  92  50  57  86  65  84  69  91\n",
       "26  54  70  52  75  61  87  98  93  51\n",
       "27  61  84  86  69  87  91  90  57  69\n",
       "28  50  71  77  70  95  75  64  56  81\n",
       "29  79  68  67  70  88  92  79  94  93\n",
       "30  64  58  92  88  80  98  89  87  52\n",
       "31  83  51  86  63  56  50  91  85  82\n",
       "32  91  82  54  61  51  52  70  84  98\n",
       "33  61  98  73  79  92  84  82  76  89\n",
       "34  54  71  69  92  55  92  58  95  79\n",
       "35  87  75  78  99  88  64  61  90  58\n",
       "36  81  73  82  56  69  53  68  78  60\n",
       "37  52  67  69  92  86  57  84  77  66\n",
       "38  64  92  87  89  75  69  54  59  90\n",
       "39  68  93  60  57  61  93  87  92  79\n",
       "40  50  53  61  71  66  56  85  67  81\n",
       "41  91  52  79  58  69  85  72  61  51\n",
       "42  90  82  69  76  59  91  88  97  72\n",
       "43  68  98  93  89  76  97  83  96  66\n",
       "44  81  99  92  96  71  84  74  79  73\n",
       "45  60  71  62  50  99  58  89  60  76\n",
       "46  71  64  60  71  99  72  70  92  89\n",
       "47  67  73  62  82  50  81  83  81  56\n",
       "48  56  97  57  58  79  65  76  59  54\n",
       "49  84  83  65  53  54  71  56  74  61\n",
       "50  59  88  50  94  86  87  60  62  91\n",
       "51  88  76  92  95  55  87  57  50  64\n",
       "52  99  94  81  85  91  94  64  92  54\n",
       "53  82  68  75  54  77  59  50  90  50\n",
       "54  59  96  68  63  56  72  84  96  56\n",
       "55  68  81  55  65  81  94  93  77  92\n",
       "56  65  59  53  55  60  66  62  70  71\n",
       "57  64  77  85  91  50  84  94  98  61\n",
       "58  63  55  65  90  62  81  59  74  68\n",
       "59  72  74  97  96  74  52  95  73  56"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 删除旧索引\n",
    "exameScore.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "e299aedc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['学生-1', '学生-2', '学生-3', '学生-4', '学生-5', '学生-6', '学生-7', '学生-8', '学生-9',\n",
       "       '学生-10', '学生-11', '学生-12', '学生-13', '学生-14', '学生-15', '学生-16', '学生-17',\n",
       "       '学生-18', '学生-19', '学生-20', '学生-21', '学生-22', '学生-23', '学生-24', '学生-25',\n",
       "       '学生-26', '学生-27', '学生-28', '学生-29', '学生-30', '学生-31', '学生-32', '学生-33',\n",
       "       '学生-34', '学生-35', '学生-36', '学生-37', '学生-38', '学生-39', '学生-40', '学生-41',\n",
       "       '学生-42', '学生-43', '学生-44', '学生-45', '学生-46', '学生-47', '学生-48', '学生-49',\n",
       "       '学生-50', '学生-51', '学生-52', '学生-53', '学生-54', '学生-55', '学生-56', '学生-57',\n",
       "       '学生-58', '学生-59', '学生-60'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "exameScore.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b41bcfac",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
